Database configuration settings

There are many database caches and settings available to help you with optimizing your database.

As you know, optimally storing your data is the job of a properly configured database outline. A properly configured outline can also have an effect on calculation performance, data load performance, and data retrieval performance.

Data retrieval buffers

When it comes to loading, retrieving, calculating, and extracting your data, performance optimizing is the job of caches and buffers. During reporting, data retrieval cache and buffer settings are used to obtain optimal retrievals of the data.

One pair of settings that you cannot go wrong with is the Data retrieval buffers settings, found on the General tab of the Database ...

Get Oracle Essbase 9 Implementation Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.