Decision support queries sometimes require large amounts of database processing. The Oracle BI Server can save the results of a query in cache files and then reuse those results later when a similar query is requested. Using cache, the cost of database processing only needs to be paid once for a query, not every time the query is run.

This section explains query caching and how it is implemented in the Oracle BI Server.

NOTE:  For information about how to use Delivers to seed the Oracle BI Server Cache, refer to Oracle Business Intelligence Presentation Services Administration Guide.

This chapter contains the following topics:

• About the Oracle BI Server Query Cache
• Query Cache Architecture
• Configuring Query Caching
• Monitoring and Managing the Cache
• Purging and Maintaining Cache Using ODBC Procedures
• Strategies for Using the Cache
• Creating Aggregates for Oracle BI Server Queries
• Cache Event Processing with an Event Polling Table
• Making Changes to a Repository
• Using the Cache Manager
• About the Refresh Interval for XML Data Sources