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;
当前系统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;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/20516214/viewspace-1375647/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/20516214/viewspace-1375647/