SESSION_ID

NUMBER

Session holding or acquiring the lock

OWNER

VARCHAR2(30)

NOT NULL

Owner of the lock

NAME

VARCHAR2(30)

NOT NULL

Name of the lock

MODE_HELD

VARCHAR2(13)

The type of lock held. The values are:

• ROWS_S (SS): row share lock
• ROW-X (SX): row exclusive lock
• SHARE (S): share lock
• S/ROW-X (SSX): exclusive lock
• NONE: lock requested but not yet obtained

MODE_REQUESTED

VARCHAR2(13)

Lock request type. The values are:

• ROWS_S (SS): row share lock
• ROW-X (SX): row exclusive lock
• SHARE (S): share lock
• S/ROW-X (SSX): exclusive lock
• NONE: Lock identifier obtained; lock not held or requested

LAST_CONVERT

NUMBER

The last convert

BLOCKING_OTHERS

VARCHAR2(40)

Blocking others