1. Database Administrator's Guide for Oracle Essbase
  2. Design Aggregate Storage Applications
  3. Aggregate Storage Applications, Cubes, and Outlines
  4. Compact the Aggregate Storage Outline

Compact the Aggregate Storage Outline

The Essbase aggregate storage (ASO) outline increases in size as it changes; for example, when members are added or deleted. You can decrease the outline size by compacting it. After the outline is compacted, its size continues to grow as before, when members are added or deleted.

Compacting the outline causes Essbase to restructure the outline, and can take place only when no other users or processes are actively using the database. Compacting the outline does not cause Essbase to clear the data.

Note:

When a member is deleted from the outline, the corresponding record of that member in the outline is marked as deleted, but the record remains in the outline. Compacting the outline does not remove the records of deleted members.

To compact an ASO outline, you can use the MaxL alter database statement.