Specifies the percentage of obsolete space in the security file (essbase.cfg) that is a factor in triggering compaction of that file.
SECURITYFILECOMPACTIONPERCENT n
n | 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 security entities can cause fragmentation in the security file (essbase.sec): filters, users, groups, applications, databases, substitution variables, disk volumes, passwords, and other Essbase objects.
Analytic Services 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" Analytic Server property.
SECURITYFILECOMPACTIONPERCENT 30
display system security file fragmentation_percent;
(MaxL)
alter system compact
security file
(MaxL)
COMPACT (Agent command), in the Database Administrator's Guide
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |