1同行回答
查看活动SESSION 数，如果活动session 有很多，则表示系统较忙，或压力较大，致多少活动 session 算多，就要看应用系统的情况了：
select a.sid||','||a.serial# as sess ,a.username,a.sql_hash_value,a.last_call_et ET,substr(a.program,1,39) program
,b.name as command ,to_char(a.logon_time,'mm-dd hh24:mi') as logon_time,machine
from v$session a ,audit_actions b
where a.command=b.action(+) and a.status='ACTIVE' and (upper(program) not like 'ORACLE%' or program is null)
order by last_call_et asc;收起
select a.sid||','||a.serial# as sess ,a.username,a.sql_hash_value,a.last_call_et ET,substr(a.program,1,39) program
,b.name as command ,to_char(a.logon_time,'mm-dd hh24:mi') as logon_time,machine
from v$session a ,audit_actions b
where a.command=b.action(+) and a.status='ACTIVE' and (upper(program) not like 'ORACLE%' or program is null)
order by last_call_et asc;收起
浏览869