SET pages 100
SELECT sql_text, executions,
ROUND ((disk_reads + buffer_gets) / executions, 2) average,
(disk_reads + buffer_gets) READS, first_load_time
FROM v$sql
WHERE 1 = 1
--and UPPER(sql_text) like '%LATEST%'
--and UPPER(sql_text) not like '%DUAL%'
AND executions != 0
ORDER BY (disk_reads + buffer_gets);
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment