Cache Management in 10g

The query cache allows the Oracle BI Server to satisfy many subsequent query requests without having to access back-end databases.
Cache Parameters in NQSConfig.INI
Most of the configurations are provided on the NQSConfig.INI.
Steps to configure Cache strategies…
As updates occur on the back-end databases, the query cache entries can become stale. Therefore, Oracle BI Administrators need to periodically remove entries from the query cache using one of the following methods.                                                                                                                                                                  
Methods of Purging cache entries
  1. Configuring cache parameters in the NQSConfig.INI
  2. Controlling cache at physical layer in Administrator tool
  3. Using Cache manager to manually purge cache entries
  4. Automatically purging cache entries
  5. Seeding cache and event pooling table
Labels: