select
  ADDR,                                    -- ADDR RAW(8)
  LATCH#,                                  -- LATCH# NUMBER
  LEVEL#,                                  -- LEVEL# NUMBER
  NAME,                                    -- NAME VARCHAR2(64)
  HASH,                                    -- HASH NUMBER
  GETS,                                    -- GETS NUMBER
  MISSES,                                  -- MISSES NUMBER
  SLEEPS,                                  -- SLEEPS NUMBER
  IMMEDIATE_GETS,                          -- IMMEDIATE_GETS NUMBER
  IMMEDIATE_MISSES,                        -- IMMEDIATE_MISSES NUMBER
  WAITERS_WOKEN,                           -- WAITERS_WOKEN NUMBER
  WAITS_HOLDING_LATCH,                     -- WAITS_HOLDING_LATCH NUMBER
  SPIN_GETS,                               -- SPIN_GETS NUMBER
  SLEEP1,                                  -- SLEEP1 NUMBER
  SLEEP2,                                  -- SLEEP2 NUMBER
  SLEEP3,                                  -- SLEEP3 NUMBER
  SLEEP4,                                  -- SLEEP4 NUMBER
  SLEEP5,                                  -- SLEEP5 NUMBER
  SLEEP6,                                  -- SLEEP6 NUMBER
  SLEEP7,                                  -- SLEEP7 NUMBER
  SLEEP8,                                  -- SLEEP8 NUMBER
  SLEEP9,                                  -- SLEEP9 NUMBER
  SLEEP10,                                 -- SLEEP10 NUMBER
  SLEEP11,                                 -- SLEEP11 NUMBER
  WAIT_TIME                                -- WAIT_TIME NUMBER
from
  GV$LATCH_PARENT
where
  inst_id = USERENV('Instance')