Using Incremental Restructuring

You can enable incremental restructuring for any of the following databases:

To enable incremental restructuring, use the INCRESTRUC configuration setting in the essbase.cfg file. See the Oracle Essbase Technical Reference.

Essbase logs outline changes in an internal file, dbname.ocl. Essbase clears the file when it does a dense restructure or when you clear or reset the database. The file dbname.ocl can grow quite large. To clear this file, issue VALIDATE in ESSCMD, which causes Essbase to restructure any blocks whose restructure was deferred. When you issue VALIDATE, ensure that the database is not in read-only mode (which is used for backing up a database). See Using VALIDATE to Check Integrity.