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

Managing the cache

Managing the cache is very critical in the BI Server. Although it brings many advantages, if it's not managed successfully end users may access old results from the cache.

How to do it...

  1. We need to purge the cache whenever the data warehouse is refreshed or updated. We can achieve this by defining the Cache Persistence Time value. This setting is on the General tab of the Physical table. If you set it as one day, then the lifetime of this table in the cache will be a maximum of one day.
    How to do it...
  2. The second method is more popular. You'll need to create a job that will execute the script as follows:
    SAPurgeAllCache()
    

    When you run this script, ...

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