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
where
  inst_id = USERENV('Instance')