Oracle Database Administration: The Essential Refe

Locks and latches

These views provide information about the status of locks and latches within the instance:

V$ACCESS

Lists all locked objects in the database and the sessions accessing these objects.

V$BUFFER_POOL

Provides information about the available buffer pools. The number of buffer pools is related to the INIT.ORA parameter DB_BLOCK_LRU_LATCHES.

V$ENQUEUE_LOCK

Lists all locks owned by enqueue state objects.

V$LATCH

Provides statistics for all latches. If the latch is a parent latch, provides a summation of the statistics for each of its children latches.

V$LATCH_CHILDREN

Provides statistics for all children latches.

V$LATCH_MISSES

Provides statistics about all failures to acquire a latch.

V$LATCH_PARENT

Provides statistics for all parent latches.

V$LATCHHOLDER

Provides information about current latch holders.

V$LATCHNAME

Provides a decoded latch name for every latch listed in V$LATCH. There is a one-to-one correspondence between these two views.

V$LOCK

Lists all locks held and all outstanding requests for locks or latches.

V$LOCKED_OBJECT

Lists all objects currently locked by transactions within the system.

V$RESOURCE

Contains the names, types, and addresses of all resources in the system.