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 ratio fromv$rollstat a,v$rollname b where a.usn=b.usn;

　　3.监控表空间的I/O比例:

　　selectdf.tablespace_namename,df.file_name "file",f.phyrds pyr,f.phyblkrd pbr,f.phywrtspyw,f.phyblkwrtpbw fromv$filestatf,dba_data_files df

　　where f.file#=df.file_id