O'Reilly logo

Oracle Internals: An Introduction by Steve Adams

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required