Re: v$sqlarea update frequency

If I recall Graham Wood's presentation at UKOUG correctly (and can read my notes), in 10gR1 or earlier, it is updated when the statement finishes. In 10gR2, it is update every 5 seconds.

I have not tested this, so take with a grain of salt.

Regards,
Daniel Fink

Binh Pham wrote:
>
> K,
>
> Thanks. However, I kept querying the v$sqlarea for the same
> hash_value and did not see it changed for a while later (much longer
> than 3 seconds).
>
>
>
>
>
> ------------------------------------------------------------------------
> From: /K Gopalakrishnan <kaygopal_at_yahoo.com>/
> Reply-To: /kaygopal_at_yahoo.com/
> To: /binhpham15_at_hotmail.com, oracle-l_at_freelists.org/
> Subject: /Re: v$sqlarea update frequency/
> Date: /Fri, 12 Jan 2007 15:06:32 -0800 (PST)/
>
> IIRC it is 3 seconds. Some of the structures take longer time(
> means they are not updated till the call ends)
>
>
> Best Regards,
> K Gopalakrishnan,
> http://www.oracle.com/technology/community/oracle_ace/ace1.html#gopalakrishnan
>
> Author: Oracle Database 10g RAC Handbook, Oracle Press 2006
> http://www.amazon.com/gp/product/007146509X/
>
> Co-Author: Oracle Wait Interface: Oracle Press 2004.
> http://www.amazon.com/gp/product/007222729X/
>
>
> ----- Original Message ----
> From: Binh Pham <binhpham15_at_hotmail.com>
> To: oracle-l_at_freelists.org
> Sent: Friday, 12 January, 2007 1:07:57 PM
> Subject: v$sqlarea update frequency
>
> How often does Oracle update the stats in v$sqlarea (ie. rows
> processed, disk reads, etc...)
>
> Thanks.
>
>
> Get live scores and news about your team: Add the Live.com
> Football Page <http://g.msn.com/8HMBENUS/2749??PS=47575> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
> ------------------------------------------------------------------------
> Your Hotmail address already works to sign into Windows Live
> Messenger! Get it now. <http://g.msn.com/8HMBENUS/2746??PS=47575> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l