select Sql_TEXT,EXECUTIONS,ROWS_PROCESSED,BUFFER_GETS/100,DISK_READS/100
FROM V$sql V,(SELECT SUM(BUFFER_GETS) TOT_GETS FROM V$SQL) S
WHERE BUFFER_GETS > TOT_GETS * 0.1
ORDER BY BUFFER_GETS DESCSelected SQL is the most cost SQL (>10% of total gets)
FROM V$sql V,(SELECT SUM(BUFFER_GETS) TOT_GETS FROM V$SQL) S
WHERE BUFFER_GETS > TOT_GETS * 0.1
ORDER BY BUFFER_GETS DESCSelected SQL is the most cost SQL (>10% of total gets)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货