Re: oracle-l Digest V4 #150


Minor exception to worry about:

The default in 10.2 (if not 10.2) is to use
delayed invalidation on calculating statistics.

To avoid a massive cache flush during things
like the 'autotstats' job, cursors are somehow
marked for invalidation over the next few
hours.
On a completely different topic - could people think about trimming posts before responding, 
please.  It's not necessary to keep echoing the
ENTIRE chain every time you add a few lines
of comment.



Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
----- Original Message ----- From: "FreeLists Mailing List Manager" <ecartis@xxxxxxxxxxxxx> 
To: "oracle-l digest users" <oracle-l@xxxxxxxxxxxxx>

Date: Thu, 31 May 2007 13:21:46 -0400
From: "Alexander Fatkulin" <afatkulin@xxxxxxxxx>
Subject: Re: bind variable peeking and regular statistics gathering

yes it will


 ... lot's cut


plan changed considering the new variable value

On 5/31/07, Ujang Jaenudin <ujang.jaenudin@xxxxxxxxx> wrote:

all,

i'm not sure about the relation between bind variable peeking and
invalidation in the regard of regularly gathering statistics.

will the bind variable peeking will re-peek when invalidation occurs
after gathering statistics?

--
regards
ujang


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

Other related posts: