Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

V$LOCK_ACTIVITY

This is an Oracle9i Real Application Clusters view. V$LOCK_ACTIVITY displays the DLM lock operation activity of the current instance. Each row corresponds to a type of lock operation.

See Also:

Oracle9i Real Application Clusters Concepts

Column Datatype Description

FROM_VAL

VARCHAR2(4)

PCM lock initial state: NULL; S; X; SSX

TO_VAL

VARCHAR2(4)

PCM lock initial state: NULL; S; X; SSX

ACTION_VAL

VARCHAR2(51)

Description of lock conversions:

  • Lock buffers for read
  • Lock buffers for write
  • Make buffers CR (no write)
  • Upgrade read lock to write
  • Make buffers CR (write dirty buffers)
  • Downgrade write lock to read (write dirty buffers)
  • Write transaction table/undo blocks
  • Transaction table/undo blocks (write dirty buffers)
  • Make transaction table/undo blocks available share
  • Rearm transaction table write mechanism

COUNTER

NUMBER

Number of times the lock operation executed