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:
|