Compacting the Essbase Security File While the Agent is Running

Besides manually compacting the security file, you can use the SECURITYFILECOMPACTIONPERCENT configuration setting to define a percentage of fragmentation that triggers compaction automatically.

  To compact the security file without stopping the Agent, use a tool:

Tool

Topic

Location

Agent

COMPACT

Enter the Agent command at the command prompt in the Essbase Server console window

MaxL

alter system compact security file

Oracle Essbase Technical Reference

essbase.cfg

SECURITYFILECOMPACTIONPERCENT

Oracle Essbase Technical Reference

Note:

Compacting the security file while the Agent is running slows down Agent activity until the operation is completed, which could take a few minutes.