GV$DLM_ALL_LOCKS

select
USERENV ('Instance'),    -- INST_ID NUMBER
HANDLE,                  -- LOCKP RAW(4)
GRANT_LEVEL,             -- GRANT_LEVEL VARCHAR2(9)
REQUEST_LEVEL,           -- REQUEST_LEVEL VARCHAR2(9)
RESOURCE_NAME1,          -- RESOURCE_NAME1 VARCHAR2(30)
RESOURCE_NAME2,          -- RESOURCE_NAME2 VARCHAR2(30)
PID,                     -- PID NUMBER
TRANSACTION_ID0,         -- TRANSACTION_ID0 NUMBER
TRANSACTION_ID1,         -- TRANSACTION_ID1 NUMBER
GROUP_ID,                -- GROUP_ID NUMBER
OPEN_OPT_DEADLOCK,       -- OPEN_OPT_DEADLOCK NUMBER
OPEN_OPT_PERSISTENT,     -- OPEN_OPT_PERSISTENT NUMBER
OPEN_OPT_PROCESS_OWNED,  -- OPEN_OPT_PROCESS_OWNED NUMBER
OPEN_OPT_NO_XID,         -- OPEN_OPT_NO_XID NUMBER
CONVERT_OPT_GETVALUE,    -- CONVERT_OPT_GETVALUE NUMBER
CONVERT_OPT_PUTVALUE,    -- CONVERT_OPT_PUTVALUE NUMBER
CONVERT_OPT_NOVALUE,     -- CONVERT_OPT_NOVALUE NUMBER
CONVERT_OPT_DUBVALUE,    -- CONVERT_OPT_DUBVALUE NUMBER
CONVERT_OPT_NOQUEUE,     -- CONVERT_OPT_NOQUEUE NUMBER
CONVERT_OPT_EXPRESS,     -- CONVERT_OPT_EXPRESS NUMBER
CONVERT_OPT_NODEADLOCKWAIT, -- CONVERT_OPT_NODEADLOCKWAIT NUMBER
CONVERT_OPT_NODEADLOCKBLOCK, -- CONVERT_OPT_NODEADLOCKBLOCK NUMBER
WHICH_QUEUE,             -- WHICH_QUEUE NUMBER
STATE,                   -- LOCKSTATE VARCHAR2(64)
AST_EVENT0,              -- AST_EVENT0 NUMBER
OWNER_NODE,              -- OWNER_NODE NUMBER
BLOCKED,                 -- BLOCKED NUMBER
BLOCKER                  -- BLOCKER NUMBER
from
V$GES_ENQUEUE
home |  up  |  mailbox