GV$DLM_ALL_LOCKS
select inst_id, -- INST_ID NUMBER kjilkftlkp, -- LOCKP 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, -- LOCKSTATE VARCHAR2(64) kjilkftaste0, -- AST_EVENT0 NUMBER kjilkfton, -- OWNER_NODE NUMBER kjilkftblked, -- BLOCKED NUMBER kjilkftblker -- BLOCKER NUMBER from x$kjilkft

home |  up  |  mailbox