查找低效率的SQL语句

-- 查找低效率的SQL语句

set wrap off
set linesize 1000

spool e:\qin_daily\查找低效率的SQL语句_script050

Select executions,
 disk_reads,
 buffer_gets,
 round((buffer_gets - disk_reads)/buffer_gets,2) hit_radio,
 round(disk_reads/executions, 2) reads_per_run, sql_text
From v$sqlarea
Where executions > 0 and buffer_gets > 0
 and (buffer_gets - disk_reads)/buffer_gets<0.8
Order by 4 desc;

spool off

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12330444/viewspace-434601/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12330444/viewspace-434601/