1.监控大事务
select count(*) from v$transaction where status='ACTIVE' AND used_urec>=200000;
2.监控长事务
select count(*) from v$transaction where to_data(start_time,'mm/ddrr hh24:mi:ss')<sysdate-1/96 and BITAND(t.flag,128)<>128;
3.慢查询
标签：count,事务,transaction,监控,oracle,select From： https://www.cnblogs.com/dbahrz/p/17165510.html