Re: V$SQLAREA to determine most disk intensive SQL

From: gslman <vivek.gopalakrishnan_at_concert.com>
Date: 2 Mar 2004 00:49:04 -0800
Message-ID: <668c2610.0403020049.2295febe@posting.google.com>

Brian Peasland <dba_at_remove_spam.peasland.com> wrote in message news:<40436567.49200BE8_at_remove_spam.peasland.com>...
> > 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"

Brian - you are right, thanks....

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

Viv Received on Tue Mar 02 2004 - 02:49:04 CST