select
  latch#,                                  -- LATCH# NUMBER
  name,                                    -- NAME VARCHAR2(64)
  hash                                     -- HASH NUMBER
from
  gv$latchname
where
  inst_id = userenv('Instance')