select
  PID,                                     -- PID NUMBER
  SID,                                     -- SID NUMBER
  LADDR,                                   -- LADDR RAW(8)
  NAME,                                    -- NAME VARCHAR2(64)
  GETS                                     -- GETS NUMBER
from
  GV$LATCHHOLDER
where
  inst_id = USERENV('Instance')