Oracle^® Business Intelligence Presentation Services Administration Guide > Administering Oracle BI Presentation Services >

Managing the Oracle BI Presentation Services Cache Settings

The entries described in this section are available for managing the Oracle BI Presentation Services cache:

• Specifying the Maximum Amount of Time an Entry Can Exist in the Oracle BI Presentation Services Cache
• Specifying the Least Amount of Time an Entry Can Exist in the Oracle BI Presentation Services Cache
• Specifying the Least Amount of Time an Entry Can Exist in the Oracle BI Presentation Services Cache After Use
• Specifying the Maximum Number of Oracle BI Presentation Services Open Record Sets

The cache is accessed when users make requests in Answers. This is not the same cache that is accessed by the Oracle BI Server. You can change the internal defaults by modifying the Oracle BI Presentation Services configuration file (instanceconfig.xml) to add the cache entries.

For information about working in the Oracle BI Presentation Services configuration file (instanceconfig.xml), read Making Oracle BI Presentation Services Configuration Changes.

Specifying the Maximum Amount of Time an Entry Can Exist in the Oracle BI Presentation Services Cache

You can override the maximum amount of time, in minutes, that an entry in the cache can exist before it is removed. The internal default is 60 (one hour).

Depending on (the number of requests being run, an entry may be removed before the time limit expires.

NOTE:  The setting for CacheMinUserExpireMinutes, described in Specifying the Maximum Amount of Time an Entry Can Exist in the Oracle BI Presentation Services Cache, can force an entry for a particular user to exist for a longer time than that specified by CacheMaxExpireMinutes.

The following entry is an example:

<CacheMaxExpireMinutes>60</CacheMaxExpireMinutes>

Specifying the Least Amount of Time an Entry Can Exist in the Oracle BI Presentation Services Cache

You can override the minimum amount of time, in minutes, that an entry in the cache can exist before it is removed. The internal default is 10.

The following entry is an example:

<CacheMinExpireMinutes>10</CacheMinExpireMinutes>

Specifying the Least Amount of Time an Entry Can Exist in the Oracle BI Presentation Services Cache After Use

You can override the minimum amount of time, in minutes, that an entry in the cache can exist after it has been viewed by a user. The internal default is 10.

For example, if CacheMaxExpireMinutes is set to 60 minutes and a user views the entry during the 59th minute, the entry exists for that user for an additional 10 minutes. The user can continue paging through the data without requiring a new request to be run.

The following entry is an example:

<CacheMinUserExpireMinutes>10</CacheMinUserExpireMinutes>

Specifying the Maximum Number of Oracle BI Presentation Services Open Record Sets

You can override the maximum number of open record sets that Oracle BI Presentation Services keeps open at any one time. The internal default is 10. The minimum value is 3. For systems under significant loads, you can increase this value to 500 or 1000.

The following entry is an example:

<CacheMaxEntries>100</CacheMaxEntries>