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

Gathering cache statistics

Cache statistics can be gathered by using Cache Manager. It's a tool that is part of the BI Administration Tool. These statistics will help us to understand the queries that are satisfied from the cache. If most of the time the queries are not being retrieved from the cache, it means that we're not managing the cache successfully.

How to do it...

  1. Open the BI AdministrationTool in online mode. Cache Manager is not activated if you open the repository in offline mode. Click on the Cache menu item from the Manage menu list.
    How to do it...
  2. Cache Manager is going to be opened. You'll see the cached objects and queries in this window.
  3. We'll have ...

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