通过视图查历史等待事件
过去发生的等待事件,我们可以通过什么视图查出来呢?
1.自实例启动以来
select * from ( select event,total_waits,time_waited,wait_class from v$system_event where wait_class<>'Idle' order by 3 desc )where rownum<=50; 9i select * from ( select event,total_waits,time_waited from v$system_event where event not in ('rdbms ipc message','pmon timer','smon timer','SQL*Net message from client','rdbms ipc reply','SQL*Net more data from client') order by 3 desc )where rownum<=50;
2.当前已连接的各会话的历史等待事件信息
select * from (select event, wait_class, sum(total_waits), sum(time_waited) from v$session_event where wait_class <> 'Idle' group by event, wait_class order by sum(time_waited) desc) where rownum < 20;
9i select * from (select event, sum(total_waits), sum(time_waited) from v$session_event where event not in ('rdbms ipc message','pmon timer','smon timer','SQL*Net message from client','rdbms ipc reply','SQL*Net more data from client') group by event order by sum(time_waited) desc) where rownum < 20;
3.当前已连接的某SESSION的历史等待事件信息
select * from (select sid, event, total_waits, time_waited from v$session_event where sid=&1 order by sid asc,time_waited desc) where event not like '%rdbms ipc%' and event not like '%SQL*Net message%';
9i: select sid, event, total_waits, time_waited from v$session_event where sid in (&1) order by sid asc,time_waited desc
备注: total_waits代表总共等待的次数,比较重要的是time_waited的,这反映了用户的等待体验,time_waited是百分之一秒。
- 06-16卡巴斯基郑启良:支持信创发展是卡巴斯基的重要使命
- 06-16访问管理是确保现代工作场所安全的的五个关键原因
- 06-16零信任安全的演变:彻底改变网络安全策略
- 06-16GitHub上值得关注的20个网络安全项目
- 06-16英国曼彻斯特大学遭遇网络攻击,机密数据或遭窃!
- 06-16调查表明广告软件推送恶意软件感染了六万多个安卓应用程序
- 06-16微软向美国政府提供GPT的大模型,安全性如何保证?
- 06-16如何保护OT环境免受安全威胁?
- 01-11全球最受赞誉公司揭晓:苹果连续九年第一
- 12-09罗伯特·莫里斯:让黑客真正变黑
- 12-09谁闯入了中国网络?揭秘美国绝密黑客小组TA
- 12-09警示:iOS6 惊现“闪退”BUG
- 04-29通用智能人“通通”亮相中关村论坛
- 04-29拼多多投入45亿补贴,助力上海“五五购物节
- 04-29通义千问再开源 推出最大尺寸1100亿参数模型
- 04-29【环球视线】比亚迪交付首列出海云轨
- 04-21中国产品数字护照体系加速建设