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_at_freelists.org> To: "oracle-l digest users" <oracle-l_at_freelists.org>
  > Date: Thu, 31 May 2007 13:21:46 -0400
  > From: "Alexander Fatkulin" <afatkulin_at_gmail.com>
  > 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_at_gmail.com> 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