To Enable Cache

Enable Cache

Cache: Cache generally holds the queries for the report that is executed by the user in presentation services. This will increase the query response time if the same type of query is accessed frequently.

Cache Queries will be stored in the log file. The level of detail in the log file will be controlled with log level. In OBIEE, We have different types of log level. They are

log level = 0 (No logging)

log level = 1 ( Sql statement issued by the client application, query processing time, query status)

log level = 2 ( level 1 details and repository name, bmm, subject area, queries issued against Cache & physical database, rows counts for queries issued against cache and physical database and row counts returned to the client application) 

log level = 3 ( level 2 details and logical query plan )

log level = 4 ( level 3 details and query execution plan)

log level = 5 ( level 4 details and logs intermediate row counts at various points of execution)

How to enable cache:

Cache can be enabled in two ways:

1) Nqsconfig file (in OBIEE 10g and OBIEE 11g)

Nqsconfig file is an initialization log file used by Oracle BI Server during start up. Each instance of Oracle BI Server will have its own Nqsconfig file. In OBIEE 10g, repository deployment is done with the help of Nqsconfig file whereas in OBIEE 11g it can also be done with Enterprise Manager

NQSConfig file will be located in the following path in 10g and 11g:

OBIEE 10g : D:/OracleBI/Server/Config

OBIEE 11g : OBIEE11G\instances\instance1\config\OracleBIServerComponent\coreapplication_obis1/

NQS Config file will have the following entry:

[Cache]

ENABLE = YES

To set the cache, it should be equal to YES.

2) Enterprise Manager (Only in OBIEE 11g)

To enable cache through Enterprise Manager, need to follow the below steps:

1) Login into OBIEE Enterprise Manager 

2) Then navigate to Business Intelligence -> Core application -> Capacity management -> Performance Tab

3) Under Performance tab, you will find a section Enable BI Server Cache. To enable cache,

•  Release the lock using lock and edit configuration, only then any editing is possible in EM.
•  Select Cache enabled.
•  Click Activate changes and then restart the server to apply these changes.