Re: V$SQLAREA to determine most disk intensive SQL

> SELECT executions*disk_reads||','||executions||','||disk_reads||','||

Shouldn't that be DISK_READS/EXECUTIONS? DISK_READS are the total number of disk reads for all EXECUTIONS. Dividing that number gives you disk reads per execution of the SQL statement.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"