OBIPS - (Query|Result|Cursor) Cache

About

When users access objects that run queries (Answers, Prompts, …), Presentation Services caches the results of the queries. This kind of cache is a client result cache.

Presentation Services determines if subsequent analytics can use cached results by asking a shared request key with the help of the odbc function sagetsharedrequestkey. If the cache can be shared, then subsequent analyses are not stored.

The files for the Presentation Services cache:

• have names such as nQS_xxxx_x_xxxxxx.TMP.
• are created by the ODBC driver but generally do correspond to ODBC requests that the Presentation Services cache keeps open.
• are stored in the following directory:
  • for 11g: ORACLE_INSTANCE\tmp\OracleBIPresentationServices\coreapplication_obipsn\obis_temp

Articles Related

How to

Clear the Cache

Manually

• Using Administration > Manage Sessions

• Shutting down cleanly Presentation Services remove the files for the cache
• Deleting the files when Presentation Services is not running and that it shuts down unexpectedly (then various cache files might be left on disk)

Soap

Obiee as a SOAP API that you can use to purge the cache : OBIEE - Web Services API (SOAP,WSDL)

Configure it

To configure the presentation service cache, you can add the following entries in the instanceconfig.xml file such as:

<ServerInstance>
  <Cache>
    <Query>
      <MaxEntries>100</MaxEntries>
      <MaxExpireMinutes>60</MaxExpireMinutes>
      <MinExpireMinutes>10</MinExpireMinutes>
      <MinUserExpireMinutes>10</MinUserExpireMinutes>
    </Query>
  </Cache>
<ServerInstance>

CacheMaxEntries

Specifying the Maximum Number of Open Record Sets

You can override the maximum number of open record sets that Presentation Service 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>

CacheMaxExpireMinutes

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).

The following entry is an example:

<CacheMaxExpireMinutes>60</CacheMaxExpireMinutes>

Specifying the Least Amount of Time an Entry Can Exist in the Cache

CacheMinExpireMinutes

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 Cache After Use

CacheMinUserExpireMinutes

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>

Documentation / Reference

• Managing the Oracle BI Presentation Services Cache Settings
• 7.6.2.2 About Sharing the Presentation Services Query Cache