Customizing Database Settings

You can customize settings for each database on Essbase Server. The information in this section helps you understand what each setting controls, how to specify settings, and lists examples. For a table of performance-related settings, see Improving Essbase Performance.

Note:

Configure settings that are applied to an entire Essbase Server in essbase.cfg. For more information, see the Oracle Essbase Technical Reference.

Table 153 lists the major database settings that you can customize:

Table 153. Major Kernel Settings

Setting

See

Index cache size

Sizing the Index Cache

Data file cache size

Sizing the Data File Cache

Data cache size

Sizing the Data Cache

Cache memory locking

Deciding Whether to Use Cache Memory Locking

Disk volumes

Storage Allocation

Data compression

Data Compression

Isolation level

Understanding Isolation Levels

The following sections describe how to change kernel settings and list examples.