V$SQLAREA to determine most disk intensive SQL

Hi,

I am attempting to find the most expensive disk SQL using this query -

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

        '"'||REPLACE(RTRIM(LTRIM(sql_text)),'"','')||'",'||first_load_time FROM V$SQLAREA
where disk_reads > 10000
order by executions*disk_reads desc

What does it mean when I sometimes get back a call to a stored procedure such as - ie. do the figures relate to the individual SQL within the stored procedure ??

BEGIN P_SPROCEDURE(:1,:2,:3); END; Thanks
Viv Received on Mon Mar 01 2004 - 09:31:17 CST