Oracle Internals: An Introduction

Reference

This section contains a quick reference to the parameters, events, statistics, waits, and APT scripts mentioned in Chapter 5.

Parameters

Parameter	Description
_FREEZE_DB_FOR_FAST_INSTANCE_RECOVERY	Whether to freeze database activity during the transaction recovery phase of instance recovery. Defaults to TRUE if any data files use fine-grained locking.
_GC_CLASS_LOCKS	The number of releasable lock elements to reserve for fine-grained locking of the minor class blocks.
_GC_LATCHES	The number of lock element latches per partition of the lock elements fixed array. Defaults to two times the number of CPUs, which is ample.
_GC_LCK_PROCS	The number of LCKn processes. Defaults to 1, which is normally sufficient.
_IGNORE_FAILED_ESCALATES	Attempts to convert a PCM lock straight after a ping appears to fail because Oracle does not know which instance last modified the protected blocks. However, this merely means that the lock value block is invalid and cannot be used for SCN generation. The lock is usable in every other respect, and so the default setting of TRUE should be accepted. This parameter is not available in release 8.1.
_KGL_MULTI_INSTANCE_INVALIDATION	This can be set to FALSE to disable global library cache invalidation locks.
_KGL_MULTI_INSTANCE_LOCK	This can be set to FALSE to disable global library cache locks.
_KGL_MULTI_INSTANCE_PIN	This can be set to FALSE to disable global library cache pins.
_LM_DIRECT_SENDS	The processes that can send ...