LOCKP 

RAW(4) 

Lock Pointer 

GRANT_LEVEL 

VARCHAR2(9) 

Granted level of the lock 

REQUEST_LEVEL 

VARCHAR2(9) 

Requested level of the lock 

RESOURCE_NAME1 

VARCHAR2(30) 

Resource name for the lock 

RESOURCE_NAME2 

VARCHAR2(30) 

Resource name for the lock 

PID 

NUMBER 

Process identifier which holds the lock 

TRANSACTION_ID0  

NUMBER 

Lower 4 bytes of the transaction identifier where the lock belongs to  

TRANSACTION_ID1 

NUMBER 

Upper 4 bytes of the transaction identifier where the lock belongs to 

GROUP_ID 

NUMBER 

Group identifier for the lock 

OPEN_OPT_DEADLOCK 

NUMBER 

1 if DEADLOCK open option is set, otherwise 0 

OPEN_OPT_PERSISTENT 

NUMBER 

1 if PERSISTENT open option is set, otherwise 0 

OPEN_OPT_PROCESS _OWNED 

NUMBER 

1 if PROCESS_OWNED open option is set, otherwise 0 

OPEN_OPT_NO_XID 

NUMBER 

1 if NO_XID open option is set, otherwise 0 

CONVERT_OPT _GETVALUE 

NUMBER 

1 if GETVALUE convert option is set, otherwise 0 

CONVERT_OPT _PUTVALUE 

NUMBER 

1 if PUTVALUE convert option is set, otherwise 0 

CONVERT_OPT _NOVALUE 

NUMBER 

1 if NOVALUE convert option is set, otherwise 0 

CONVERT_OPT _DUBVALUE 

NUMBER 

1 if DUBVALUE convert option is set, otherwise 0 

CONVERT_OPT _NOQUEUE 

NUMBER 

1 if NOQUEUE convert option is set, otherwise 0 

CONVERT_OPT_EXPRESS 

NUMBER 

1 if EXPRESS convert option is set, otherwise 0 

CONVERT_OPT_ NODEADLOCKWAIT 

NUMBER 

1 if NODEADLOCKWAIT convert option is set, otherwise 0 

CONVERT_OPT_ NODEADLOCKBLOCK 

NUMBER 

1 if NODEADLOCKBLOCK convert option is set, otherwise 0 

WHICH_QUEUE 

NUMBER 

Which queue the lock is currently located. 0 for NULL queue; 1 for GRANTED queue; 2 for CONVERT queue 

LOCKSTATE 

VARCHAR2(64) 

State of lock as owner sees it 

AST_EVENT0 

NUMBER 

Last AST event 

OWNER_NODE  

NUMBER 

Node identifier 

BLOCKED  

NUMBER 

1 if this lock request is blocked by others, otherwise 0 

BLOCKER 

NUMBER 

1 if this lock is blocking others, otherwise 0