Wednesday, April 09, 2008

Cursor details in shared pool with statistics in Oracle

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);

No comments: