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$_LOCK where inst_id = USERENV('Instance')