[OracleScript]checklatch

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;

网站题目:[OracleScript]checklatch
文章地址:https://www.cdcxhl.com/article20/jdhdco.html

成都网站建设公司_创新互联,为您提供自适应网站用户体验电子商务网站设计公司网站导航网站设计

广告

声明:本网站发布的内容(图片、视频和文字)以用户投稿、用户转载内容为主,如果涉及侵权请尽快告知,我们将会在第一时间删除。文章观点不代表本网站立场,如需处理请联系客服。电话:028-86922220;邮箱:631063699@qq.com。内容未经允许不得转载,或转载时需注明来源: 创新互联

成都app开发公司