OBIEE Cache Management

Back Ground

Business Intelligence system user usually queries a larger Data Warehouse or Data Marts.
And when ask few import things they are looking for, and performance ALWAYS comes!!!. Cache helps to make a BIG win when it comes to performance.

So Cache helps us in
1) Achieving better performance for query by not going to Database server and satisfying request from cache file on OBIEE server itself.( There are some criteria for cache hit to occur)
2) It saves network resources by not make round trip.

But with performance comes some cost.
1) Human Resources to mange
2) Physical Resource (data storage etc)
3) Keeping cache up to date. (If users gets data quickly but its not fresh/updated then it does not make sense either).

Below is the process flow or Architecture of OBIEE cache

Cache System ArchictureCache System Archicture

Steps to Configure the Cache

Step1: Change NQSConfig.ini file

Go to \ OracleBI\server\Config\ NQSConfig.INI

In NQSConfig.ini go to cache section you will see something as below screen shot

Cache Sesction of Config fileCache Sesction of Config file

All the parameters are basically self explanatory like path of file , size , number of rows etc etc

Oracle suggests having cache file on high speed storage.

Step 2: Managing the cache.

We can do cache management with various techniques

A : Configuring cache parameters shown in the file above
B : Controlling cache at physical layer in Administrator tool
C :Using Cache manager
D: Automatically purging cache entries
E: Seeding cache and event pooling table.