Re: v$sqlarea update frequency

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Fri, 12 Jan 2007 15:06:32 -0800 (PST)
Message-ID: <20070112230632.62551.qmail@web57007.mail.re3.yahoo.com>

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

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

Received on Fri Jan 12 2007 - 17:06:32 CST