GV$_LOCK definition in Oracle Database 10.2 / 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$ktatrfil
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$ktatrfsl
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$ktatl
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$ktstusc
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$ktstuss
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$ktstusg
where
bitand (kssobflg, 1) !=0 and (ksqlkmod!=0 or ksqlkreq!=0)
union all
select
inst_id, -- INST_ID NUMBER
ktcxbxba, -- LADDR RAW(4)
ktcxblkp, -- 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)