O'Reilly logo

Oracle Essbase 9 Implementation Guide by Joseph Sydney Gomez, Sarma Anantapantula

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required