以下引用csdn一位兄弟的转载,可能对你有所帮助。
在sqlplus中:
a.查看回滚段的争用情况:
select name, waits, gets, waits/gets "Ratio"
from v$rollstat a, v$rollname b
where a.usn = b.usn;
b.查看事例的等待
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 count(*);
c.查看当前数据库谁在运行sql
select osuser, username, sql_text from v$session a, v$sqltext b
where a.sql_address =b.address order by address, piece;