[Oracle Script] check latch

發(fā)布時間：2020-08-11 14:24:09 來源：ITPUB博客閱讀：145 作者：tolilong 欄目：關(guān)系型數(shù)據(jù)庫

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.gets,4)*100 "Simple Gets Ratio(%)",
       l.spin_gets, round(l.spin_gets / l.gets,4)*100 "Spin Gets Ratio(%)",
       l.sleeps "Sleep Get", round(l.sleeps / l.gets,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;

向AI問一下細節(jié)

[Oracle Script] check latch

猜你喜歡

最新資訊

相關(guān)推薦

相關(guān)標(biāo)簽