Name
FREEZE_DB_FOR_FAST_INSTANCE_RECOVERY
Synopsis
Value: TRUE | FALSE
Default: see description
Dynamic: ALTER SYSTEM
Parallel Server parameter that controls whether Oracle freezes the entire database during instance recovery. If TRUE, Oracle freezes the entire database during instance recovery, which stops all other disk activities except those for instance recovery, allowing instance recovery to complete faster. If FALSE, Oracle does not freeze the entire database, unless Oracle is responsible for resilvering some of the mirrored datafiles. If all online datafiles use hash locks, the default is FALSE. If any datafiles use fine-grained locks, the default is TRUE. Multiple instances must have identical values. Obsolete with Oracle8i.