Re: V$SQLAREA to determine most disk intensive SQL

> ... any ideas about the interpretation of the stored procedure call ?

Not at this time. Try issuing the following query:

SELECT disk_reads/executions, sql_text, first_load_time FROM V$SQLAREA
where disk_reads > 10000
order by 1 desc;

See if that runs (it should). If it doesn't run satisfactorily, then post the exact error messages.

Thanks,
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"