OEM (等待事件CPU IO 应用）活动会话数统计(RAC两节点)

最新推荐文章于 2021-04-13 01:30:36 发布

最新推荐文章于 2021-04-13 01:30:36 发布 · 228 阅读

本文提供了一个Oracle数据库等待事件的统计查询脚本示例，并展示了不同等待类别的汇总数据，如User I/O、Application等。

部署运行你感兴趣的模型镜像

select a.wait_class,sum(qty)
from (select wait_class,trunc(count(session_id)/60,2) qty
from v$active_session_history
where to_char(sample_time,'hh24mi')=to_char(sysdate-1/24/60,'hh24mi')
group by wait_class
union all
select wait_class,trunc(count(session_id)/60,2) qty
from v$active_session_history@dblink
where to_char(sample_time,'hh24mi')=to_char(sysdate-1/24/60,'hh24mi')
group by wait_class)a

group by a.wait_class;

WAIT_CLASS	SUM(QTY)
	46.7
User I/O	61.18
Application	2
Network	0.67
Configuration	0.95
Administrative	1.88
Concurrency	0.48
Cluster	2.25
Other	0.09
System I/O	2.67
Commit	0.51