Manage Presentation Services Cache Settings

When users run analyses, Presentation Services can cache the results of those analyses. Presentation Services determines if subsequent analyses can use cached results. If the cache can be shared, then subsequent analyses aren't stored.

The files for the Presentation Services cache are created by the ODBC driver but generally do correspond to ODBC requests that the Presentation Services cache keeps open. The files are stored in the following directory:

BI_DOMAIN/servers/obips/cache/subFolderForEachCache

The files for the cache are removed whenever Presentation Services shuts down cleanly. If Presentation Services shuts down unexpectedly, then various cache files might be left on disk. You can delete the files when Presentation Services isn't running.

The Presentation Services cache is different from the cache that's accessed by the Oracle BI Server. You can change the defaults for the Presentation Services cache by modifying the instanceconfig.xml file to include the cache entries.

The following procedure provides information about configuration changes with which you can manage the Presentation Services cache.

See About Sharing the Presentation Services Query Cache.

  1. Open the instanceconfig.xml file for editing in:

    BI_DOMAIN/config/fmwconfig/biconfig/OBIPS

  2. Locate the section in which you must add the elements described in the table below.

    Note:

    Avoid specifying values of less than 3 minutes for the elements that affect minutes. At such a low amount of time, refreshes can occur frequently, which can negatively affect performance and cause flickering on the screen.

  3. Include the elements and their ancestor elements as appropriate, as shown in the following example:

    <ServerInstance>
      <Cache>
        <Query>
          <MaxEntries>1000</MaxEntries>
          <MaxExpireMinutes>60</MaxExpireMinutes>
          <MinExpireMinutes>10</MinExpireMinutes>
          <MinUserExpireMinutes>10</MinUserExpireMinutes>
          <RefreshIncludeBIServerCache>false</RefreshIncludeBIServerCache>
        </Query>
      </Cache>
    </ServerInstance>
  4. Save your changes and close the file.

  5. Restart Oracle Analytics Server.

About Elements to Configure the Cache

You can configure the cache elements described here.

Element Description Default Value

MaxEntries

Specifies the maximum number of open record sets that Presentation Services keeps open at any one time. The minimum value is 3. For systems under significant loads, you can increase this value to 700 or 1000.

1000

MaxExpireMinutes

Specifies the maximum amount of time, in minutes, that an entry in the cache can exist before it's removed. Depending on the number of analyses being run, an entry might be removed before the time limit expires.

60

MinExpireMinutes

Specifies the minimum amount of time, in minutes, that an entry in the cache can exist before it's removed. The setting for CacheMinUserExpireMinutes can force an entry for a particular user to exist for a longer time than that specified by the CacheMaxExpireMinutes element.

10

MinUserExpireMinutes

Specifies the minimum amount of time, in minutes, that an entry in the cache can exist after it's been viewed by a user.

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 analysis to be run.

10

RefreshIncludeBIServerCache

Specifies if the Presentation Services cache is bypassed when a dashboard or analysis is refreshed.

When you refresh an analysis or dashboard the cache is bypassed and the latest version of the data is used. Previously when you refreshed, the cache would be used. Set this parameter to false to revert to the previous behavior.

true