LOCKS

Locks

ROWID

None

Columns

Name Data Type Description
KADDR string(20) Address of lock
OWNER string(32) Owner name of object, if applicable
OBJECT string(132) Object name, if applicable
SID long Session ID
SESSION_USER string(32) Login name
TYPE string(4) Lock type. Only the following types are shown:
RW
Materialized View Flags
TM
DML enqueue (table lock)
TX
Transaction enqueue (row lock)
UL
User-defined enqueue
ID1 long Lock ID #1 (depends on type)
ID2 long Lock ID #2 (depends on type)
LMODE long Lock mode # being held
MODE_DESC string(16) Lock mode being held:
  • Exclusive (X)
  • NULL
  • Row Exclusive (SX)
  • Row Share (SS)
  • Share (S)
  • Share Row (SSX)
REQUEST long Lock mode # being requested
REQUEST_DESC string(16) Lock mode being requested:
  • Exclusive (X)
  • NULL
  • Row Exclusive (SX)
  • Row Share (SS)
  • Share (S)
  • Share Row (SSX)

Requirements

Attributes: None
Minimum database version: 8.1