W.r.

摘要： 1. 监控事例的等待select event,sum(decode(wait_Time,0,0,1)) "Prev",sum(decode(wait_Time,0,1,0)) "Curr", count(*) "Tot"from v$session_Wait group by event order by 4; 2. 回滚段的争用情况select name, waits, gets, waits/gets "Ratio" from v$rollstat a, v$rollname b where a.usn = b 阅读全文