Purging/Seeding Cache in OBIEE

Enabling Cache increases the speed of query as it will not hit the database on the query request but not always we will get refresh data,so we purge cache to get latest data.
Purging Cache/Seeding Cache can be done in Many ways:
1.At presentation services -Front End.

Using following Functions:

1.SAPurgeAllCache -Purges all cache.
2.SAPurgeCacheByDatabase-Purges all cache for a specific Physical Database.
3.SAPurgeCacheByTable-Purges cache for a specific physical table.
4.SAPurgeCacheByQuery-Purges cache for a specific query.

2.In Physical Layer - At each table level we can purge Cache/Enable Properties.

3.Using Event Polling Tables at Database level using Admin Tool.

Use of Event Polling Tables:

i)It is a way to notify the Oracle BI Server that one or more physical tables have been updated and then the query cache entries are stale.
ii)Each Row that is added to an event table describes a single update event.
iii)OBI Server cache system reads rows from the event table,extracts the physical table information from the rows and purges stale cache entries that reference those physical tables.

4.Disbling cache At NQSConifg.INI file.