select
LADDR, -- LADDR RAW(8)
KADDR, -- KADDR RAW(8)
SADDR, -- SADDR RAW(8)
RADDR, -- RADDR RAW(8)
LMODE, -- LMODE NUMBER
REQUEST, -- REQUEST NUMBER
CTIME, -- CTIME NUMBER
BLOCK -- BLOCK NUMBER
from
GV$_LOCK1
where
inst_id = USERENV('Instance')