摘要：监控SQL 1.监控事例的等待： select event,sum(decode(wait_time,0,0,1)) prev, sum(decode(wait_time,0,1,0)) curr,count(*) from v$session_wait group by event order by 4; 2.回滚段的争用情况： select name,waits,gets,waits/gets... 阅读全文