How to set Cache Settings in OBIEE 11g

Enabling Cache:

1. Go to Fusion Middleware Control and log in as weblogic.
2. In the left pane, expand Business Intelligence
3. Click coreapplication.
4. Click Capacity Management.
5. Click the Performance tab.
6. Click Lock and Edit Configuration.
7. Select Cache Enabled.
8. Click Apply to activate the changes.
9. Click Activate Changes.
10. Restart Oracle BI components to apply recent changes.

Modifying Cache Parameters:

Use Fusion Middleware Control to set query cache parameters. You can use Fusion

Middleware Control to set the maximum number of cache entries in the query cache, as

well as the maximum size for a single cache entry.

1. Return to Fusion Middleware Control, which should still be open. If it is not open, enter the http://localhost:7001/em and log in to Fusion Middleware Control as weblogic with password welcome1.
2. In the left pane, expand Business Intelligence.
3. Click coreapplication.
4. Click Capacity Management.
5. Click the Performance tab.
6. Click Lock and Edit Configuration.
7. Change Maximum cache entries from 1000 to 10000.
8. Apply and activate your changes.
9. Leave Fusion Middleware Control open, but do not restart to apply recent changes at this time.

Modifying Cache Parameters Manually

Use NQSConfig.ini to view and manually edit additional query cache parameters.

1. Navigate to D:\bi\instances\instance1\config\OracleBIServerComponent\coreapplication_obis1.
2. Before making changes to NQSConfig.ini, make a copy of the file and paste it in the same directory.
3. Open NQSConfig.ini.
4. Navigate to the CACHE section.
5. Make the following modifications:
6. Modify the MAX_ROWS_PER_CACHE_ENTRY parameter as follows: MAX_ROWS_PER_CACHE_ENTRY = 50000

This parameter controls the maximum number of rows for any cache entry. Limiting the

number of rows is a useful way to avoid using up the cache space with runaway

queries that return large numbers of rows. If the number of rows a query returns is

greater than the value specified in the MAX_ROWS_PER_CACHE_ENTRY parameter,

the query is not cached.

Notice the DATA_STORAGE_PATH parameter. This parameter specifies one or more

directories for query cache storage, and the maximum size for each storage directory.

These directories are used to store the cached query results and are accessed when a

cache hit occurs.

Notice that the MAX_CACHE_ENTRIES parameter is changed to 10000. Changes

made to cache configuration in Fusion Middleware Control are written to this file.

       7. Save and close NQSConfig.INI.
       8. Return to Fusion Middleware Control and restart Oracle BI components.