Shulou(Shulou.com)06/01 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.