GV$DLM_ALL_LOCKS definition in Oracle 8i / www.oracledba.ru
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