Re: V$SQLAREA to determine most disk intensive SQL

Hi,

I think you should not use V$ views in performance diagnosis. Because, many performance statistics of child(recursive) statements are already included in their parent statement. That means they are duplicated in V$ views.

I recommend you using event 10046. Because, it's possible to compute exclusive statistics in event 10046 traces.

regards...

danişment...

vivek.gopalakrishnan_at_concert.com (gslman) wrote in message news:<668c2610.0403010731.13174eed_at_posting.google.com>...
> 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 Thu Mar 04 2004 - 03:19:45 CST