V$LOCK definition in Oracle Database 11.2
V$LOCK

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')

home |  up