Oracle^® Business Intelligence Server Administration Guide > Query Caching in the Oracle BI Server > Using the Cache Manager >

Purging Cache

Purging cache is the process of deleting entries from the query cache. You can purge cache entries in the following ways:

• Manually, using the Administration Tool Cache Manager facility (in online mode).
• Automatically, by setting the Cache Persistence Time field in the Physical Table dialog box for a particular table.
• Automatically, by setting up an Oracle BI Server event polling table.
• Automatically, as the cache storage space fills up.

To purge the cache manually with the Cache Manager facility

1. Use the Administration Tool to open a repository in online mode.
2. Select Manage > Cache to open the Cache Manager dialog box.
3. Select Cache or Physical mode by selecting the appropriate tab in the left pane.
4. Navigate the explorer tree to display the associated cache entries in the right pane.
5. Select the cache entries to purge, and then select Edit > Purge to remove them.
   • In Cache mode, select the entries to purge from those displayed in the right pane.
   • In Physical mode, select the database, catalog, schema or tables to purge from the explorer tree in the left pane.

     In Cache mode, you can purge:

   • One or more selected cache entries associated with the open repository.
   • One or more selected cache entries associated with a specified business model.
   • One or more selected cache entries associated with a specified user within a business model.

     In Physical mode, you can purge:

   • All cache entries for all tables associated with one or more selected databases.
   • All cache entries for all tables associated with one or more selected catalogs.
   • All cache entries for all tables associated with one or more selected schemas.
   • All cache entries associated with one or more selected tables.

Purging deletes the selected cache entries and associated metadata. Select Action > Refresh or press F5 to refresh your cache display.