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 of Oracle WebLogic Server