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