GV$GES_ENQUEUE

select
inst_id,                 -- INST_ID NUMBER
kjilkftlkp,              -- HANDLE RAW(4)
kjilkftgl,               -- GRANT_LEVEL VARCHAR2(9)
kjilkftrl,               -- REQUEST_LEVEL VARCHAR2(9)
kjilkftrn1,              -- RESOURCE_NAME1 VARCHAR2(30)
kjilkftrn2,              -- RESOURCE_NAME2 VARCHAR2(30)
kjilkftpid,              -- PID NUMBER
kjilkftxid0,             -- TRANSACTION_ID0 NUMBER
kjilkftxid1,             -- TRANSACTION_ID1 NUMBER
kjilkftgid,              -- GROUP_ID NUMBER
kjilkftoodd,             -- OPEN_OPT_DEADLOCK NUMBER
kjilkftoopt,             -- OPEN_OPT_PERSISTENT NUMBER
kjilkftoopo,             -- OPEN_OPT_PROCESS_OWNED NUMBER
kjilkftoonxid,           -- OPEN_OPT_NO_XID NUMBER
kjilkftcogv,             -- CONVERT_OPT_GETVALUE NUMBER
kjilkftcopv,             -- CONVERT_OPT_PUTVALUE NUMBER
kjilkftconv,             -- CONVERT_OPT_NOVALUE NUMBER
kjilkftcodv,             -- CONVERT_OPT_DUBVALUE NUMBER
kjilkftconq,             -- CONVERT_OPT_NOQUEUE NUMBER
kjilkftcoep,             -- CONVERT_OPT_EXPRESS NUMBER
kjilkftconddw,           -- CONVERT_OPT_NODEADLOCKWAIT NUMBER
kjilkftconddb,           -- CONVERT_OPT_NODEADLOCKBLOCK NUMBER
kjilkftwq,               -- WHICH_QUEUE NUMBER
kjilkftls,               -- STATE VARCHAR2(64)
kjilkftaste0,            -- AST_EVENT0 NUMBER
kjilkfton,               -- OWNER_NODE NUMBER
kjilkftblked,            -- BLOCKED NUMBER
kjilkftblker             -- BLOCKER NUMBER
from
x$kjilkft 
union all 
select
inst_id,                 -- INST_ID NUMBER
kjbllockp,               -- HANDLE RAW(4)
kjblgrant,               -- GRANT_LEVEL VARCHAR2(9)
kjblrequest,             -- REQUEST_LEVEL VARCHAR2(9)
kjblname,                -- RESOURCE_NAME1 VARCHAR2(30)
kjblname2,               -- RESOURCE_NAME2 VARCHAR2(30)
0,                       -- PID NUMBER
0,                       -- TRANSACTION_ID0 NUMBER
0,                       -- TRANSACTION_ID1 NUMBER
0,                       -- GROUP_ID NUMBER
0,                       -- OPEN_OPT_DEADLOCK NUMBER
1,                       -- OPEN_OPT_PERSISTENT NUMBER
0,                       -- OPEN_OPT_PROCESS_OWNED NUMBER
1,                       -- OPEN_OPT_NO_XID NUMBER
0,                       -- CONVERT_OPT_GETVALUE NUMBER
0,                       -- CONVERT_OPT_PUTVALUE NUMBER
0,                       -- CONVERT_OPT_NOVALUE NUMBER
0,                       -- CONVERT_OPT_DUBVALUE NUMBER
0,                       -- CONVERT_OPT_NOQUEUE NUMBER
0,                       -- CONVERT_OPT_EXPRESS NUMBER
0,                       -- CONVERT_OPT_NODEADLOCKWAIT NUMBER
0,                       -- CONVERT_OPT_NODEADLOCKBLOCK NUMBER
kjblqueue,               -- WHICH_QUEUE NUMBER
kjbllockst,              -- STATE VARCHAR2(64)
0,                       -- AST_EVENT0 NUMBER
kjblowner,               -- OWNER_NODE NUMBER
kjblblocked,             -- BLOCKED NUMBER
kjblblocker              -- BLOCKER NUMBER
from
x$kjbl
home |  up  |  mailbox