[Oracle Script] check latch
Select l.latch# latch,l.name, nvl (c.latches, 0) children, l.gets, l.misses, l.gets-l.misses "Simple Gets"
Round ((l.gets-l.misses) / l.getsjue 4) * 100 "Simple Gets Ratio (%)"
L.spin_gets, round (l.spin_gets / l.getsrecovery4) * 100 "Spin Gets Ratio (%)"
L.sleeps "Sleep Get", round (l.sleeps / l.getspr. 4) * 100 "Sleep Gets Ratio (%)"
L.immediate_gets
L.immediate_misses
To_char (sysdate, 'yyyy/mm/dd hh34:mi:ss') currTime
From v$latch l
(SELECT latch#, count (*) latches
FROM v$latch_children c
GROUP BY latch#) c
Where l.latch# = c.latch# (+)
AND l.gets > 0
ORDER BY latch
