SQL语句排序

当前系统IO读取前10的SQL语句

select * from (select s.sql_text,s.disk_reads from v$sql s order by s.disk_reads desc) where rownum<10;

当期系统CPU时间耗费前10的SQL语句(注意这里Oracle的默认单位是微秒，换算成分钟为cpu_time/1000/1000/60)

select * from (select s.sql_text,ceil(s.cpu_time) from v$sql s order by s.cpu_time desc) where rownum<10;

当前系统SQL的总执行时间前10的SQL语句(注意这里Oracle的默认单位是微秒，换算成分钟为elapsed_time/1000/1000/60)

select * from (select s.sql_text,ceil(s.elapsed_time) from v$sql s order by elapsed_time desc) where rownum<10;

当前系统SQL的总等待时间前10的sql语句

select * from (select s.sql_text,((s.elapsed_time-s.cpu_time)/1000/1000/60) as WAIT_TIMES from v$sql s order by wait_times desc) where rownum<10;