select ADDR, -- ADDR RAW(8) KADDR, -- KADDR RAW(8) SID, -- SID NUMBER TYPE, -- TYPE VARCHAR2(2) ID1, -- ID1 NUMBER ID2, -- ID2 NUMBER LMODE, -- LMODE NUMBER REQUEST, -- REQUEST NUMBER CTIME, -- CTIME NUMBER BLOCK -- BLOCK NUMBER from GV$LOCK where inst_id = USERENV('Instance')