Specifies the percentage of obsolete space in the security file (essbase.cfg) that is a factor in triggering compaction of that file.
SECURITYFILECOMPACTIONPERCENT nWhere n is the percentage limit of obsolete space that will trigger compaction of the security file.
n is an integer between 10 and 100. The recommended value is 30.
Changing or deleting the following Essbase Server security entities can cause fragmentation in the security file (essbase.sec): filters, users, groups, applications, databases, substitution variables, disk volumes, passwords, and other Essbase Server objects.
Essbase compacts the security file automatically each time the Agent is stopped. You can use the SECURITYFILECOMPACTIONPERCENT configuration setting to trigger compaction of the security file when the agent is still running and no Agent activity has occurred for the period of time specified by the "timeout" Essbase Server property.
The timeout period is a server property defined, per user, in Administration Services or MaxL. Compaction based on the SECURITYFILECOMPACTIONPERCENT configuration setting occurs only when the timeout has caused all users to be logged out.
Once compaction is initiated through this configuration setting, if you log back in and perform a task that requires Agent activity, the task will be delayed until compaction is completed.
You can force compaction using the COMPACT Agent command or the alter system MaxL statement.
See the appropriate documentation for details.
SECURITYFILECOMPACTIONPERCENT 30
display system security file fragmentation_percent; (MaxL)
alter system compact security file (MaxL)
COMPACT (Agent command), in the Oracle Essbase Database Administrator's Guide