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
from
  gv$global_blocked_locks
where
  inst_id = userenv('instance')