5 Managing Performance Tuning and Query Caching

This chapter describes ways to improve Oracle Business Intelligence 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

This chapter includes the following sections:

• Monitoring Service Levels

• About Query Performance Tuning

• Setting Performance Parameters in Fusion Middleware Control

• About the Oracle BI Server Query Cache

• Configuring Query Caching

• Monitoring and Managing the Cache

• Strategies for Using the Cache

• Cache Event Processing with an Event Polling Table

• Managing the Oracle BI Presentation Services Cache Settings

• Improving Oracle BI Web Client Performance

• Setting the JVM Heap Size for Oracle Business Intelligence

• Capturing Metrics Using the Dynamic Monitoring Service