Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: v$sqlarea update frequency

Re: v$sqlarea update frequency

From: Binh Pham <binhpham15_at_hotmail.com>
Date: Fri, 12 Jan 2007 23:16:39 +0000
Message-ID: <BAY103-F109F3E0A9695120093FF68D2B00@phx.gbl>

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@yahoo.com>
Reply-To: kaygopal@yahoo.com
To: binhpham15@hotmail.com, oracle-l@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@hotmail.com>
To: oracle-l@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://www.freelists.org/webpage/oracle-l




Your Hotmail address already works to sign into Windows Live Messenger! Get it now. -- http://www.freelists.org/webpage/oracle-l Received on Fri Jan 12 2007 - 17:16:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US