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