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

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