Determines whether Analytic Services delays free space recovery after an application crashes or terminates abnormally.
This setting does not apply to aggregate storage databases.
DELAYEDRECOVERY [appname] TRUE | FALSE
appname | Optional. The name of an application to which this setting should apply. If omitted, all applications are affected. |
TRUE | Analytic Services delays freespace recovery. |
FALSE | Analytic Services does not delay freespace recovery. |
This setting controls whether Analytic Services delays freespace recovery.
Database recovery takes place any time you load an application that has just crashed or terminated abnormally. Essbase does not perform free space recovery automatically because it is the most expensive part of database recovery. You must either trigger freespace recovery explicitly or change the default setting so that Essbase will recover free space automatically.
DELAYEDRECOVERY TRUE
Analytic Services delays freespace recovery.
alter database <DBS-NAME> recover freespace
, which is the statement you use to explicitly recover freespace.
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |