GV$_LOCK definition in Oracle 8i / www.oracledba.ru
GV$_LOCK
select
USERENV ('Instance'), -- INST_ID NUMBER
laddr, -- LADDR RAW(4)
kaddr, -- KADDR RAW(4)
saddr, -- SADDR RAW(4)
raddr, -- RADDR RAW(4)
lmode, -- LMODE NUMBER
request, -- REQUEST NUMBER
ctime, -- CTIME NUMBER
block -- BLOCK NUMBER
from
v$_lock1
union all
select
inst_id, -- INST_ID NUMBER
addr, -- LADDR RAW(4)
ksqlkadr, -- KADDR RAW(4)
ksqlkses, -- SADDR RAW(4)
ksqlkres, -- RADDR RAW(4)
ksqlkmod, -- LMODE NUMBER
ksqlkreq, -- REQUEST NUMBER
ksqlkctim, -- CTIME NUMBER
ksqlklblk -- BLOCK NUMBER
from
x$ktadm
where
bitand (kssobflg, 1) !=0 and (ksqlkmod!=0 or ksqlkreq!=0)
union all
select
inst_id, -- INST_ID NUMBER
addr, -- LADDR RAW(4)
ksqlkadr, -- KADDR RAW(4)
ksqlkses, -- SADDR RAW(4)
ksqlkres, -- RADDR RAW(4)
ksqlkmod, -- LMODE NUMBER
ksqlkreq, -- REQUEST NUMBER
ksqlkctim, -- CTIME NUMBER
ksqlklblk -- BLOCK NUMBER
from
x$ktcxb
where
bitand (ksspaflg, 1) !=0 and (ksqlkmod!=0 or ksqlkreq!=0)