O'Reilly logo

Oracle Business Intelligence 11g R1 Cookbook by Cuneyt Yilmaz

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Enabling the cache

The queries that are executed against the data warehouses causes large amount of database processing. Every time we access an analysis, the query is going to be generated by the BI Server and it's executed against the database. In order to improve the performance, we should balance the workload by enabling the cache on the BI Server. So when the query is executed for the first time, the result set is going to be cached on the BI Server. The result set is going to be generated from the cache in the subsequent executions.

How to do it...

  1. The BI Server's cache is going to be enabled from Fusion Middleware Enterprise Manager Control. You'll see the Performance property page under the Capacity Management tab. Then click on the Lock ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required