Top expensive SQL
Rich VJan 21 2010 — edited Jan 22 2010Hello,
I have this query to derive top expensive SQLs. But I also need to derive % of shared pool area consumed by each statement. How can I get this information?
SELECT *
FROM (SELECT Substr(a.sql_text,1,50) sql_text,
Trunc(a.disk_reads/Decode(a.executions,0,1,a.executions)) reads_per_execution,
a.buffer_gets,
a.disk_reads,
a.executions,
a.sorts,
a.address
FROM v$sqlarea a
ORDER BY 2 DESC)
WHERE rownum <= 10
Thanks,
R