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