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@xxxxxxxxx>
To: binhpham15@xxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
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,
Author: Oracle Database 10g RAC Handbook, Oracle Press 2006
Co-Author: Oracle Wait Interface: Oracle Press 2004.
----- Original Message ----
From: Binh Pham <binhpham15@xxxxxxxxxxx>
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...)
Get live scores and news about your team: Add the Live.com Football Page -- http://www.freelists.org/webpage/oracle-l