7 Manage Performance Tuning and Query Caching

This chapter describes ways to improve query performance, including a performance tuning overview and information about monitoring system metrics. It also describes how to manage and use the query cache, a feature that enables the Oracle BI Server to 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 must be paid only once for a query, not every time the query is run.

See also the following Oracle Fusion Middleware resources on performance tuning for your system:

Tuning Performance

Tuning Performance of Oracle WebLogic Server

Topics:

• Monitor Service Levels

• About Query Performance Tuning

• Set Performance Parameters in Fusion Middleware Control

• About the BI Server Query Cache

• Configure Query Caching

• Monitor and Manage the Cache

• Strategies for Using the Cache

• Cache Event Processing with an Event Polling Table

• Configure the Data Source Cache

• Manage Presentation Services Cache Settings

• Improve Web Client Performance

• Optimize Performance by Setting the JVM Heap Size

• Improve Performance when Downloading Large Reports

• Capture Metrics Using the Dynamic Monitoring Service