By default, the Oracle BI Server maintains a local, disk-based cache of query result sets (query cache). The query cache dramatically decreases query response time by enabling the Oracle BI Server to satisfy many subsequent query requests without having to access back-end data sources.
Oracle recommends that caching be turned on. When setting the cache entry size and the number of cache entries, consider the amount of data that is being generated, and the frequency of changes to manage the affect on performance, while maintaining the information that you require.
To set the BI Server cache:
Go to: http://server name:7001/em
to open Enterprise Manager.
In the left pane of Enterprise Manager, select Business Intelligence, and then the instance name; for example, coreapplication.
In the right pane, select Capacity Management, and then Performance to display the Performance options.
Under Enable BI Server Cache, click Cache Enabled.
The cache is enabled by default. To disable the cache, clear the checkbox.
Under Maximum cache entry size, enter the maximum size for a cache entry in MB. Potential entries that exceed this size are not cached. The default size is 20 MB.
Under Maximum cache entries, enter the maximum number of cache entries allowed in the query cache. Use this value to help manage your cache storage requirements. The default value is 1000.
At the top of the screen, click Restart to Apply Recent Changes.
As a courtesy, ensure that the restart will not affect other users. When the server is rebooted, the new caching requirements are applied.