Configuring the Data and Index Cache Sizes

If your system has enough memory, before you create an application, to improve performance, you may want to configure the essbase.cfg file to increase the index cache to 256 MB or more and increase the data cache to 2 GB or more. Changing these settings does not affect existing applications. You can increase the index and data cache for each application using either Oracle Essbase Administration Services or manually using MaxL statements. For example, using MaxL:

alter databaseName planType set data_cache_size 20000MB

alter databaseName planType set index_cache_size 256MB

Note:

Ensure that your system has enough memory for these suggested settings. If it does not, lower the settings. For more information, see Oracle Essbase Database Administrator's Guide.