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: Bind variable peeking and Dynamic sampling

Re: Bind variable peeking and Dynamic sampling

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Tue, 08 May 2007 08:25:23 -0600
Message-Id: <20070508142453.9D05B6DB624@turing.freelists.org>


If it's the "plan flipping" that you are concerned about, the easiest solution is to get rid of the histogram(s) on the predicate column(s). You can then "play" with the density or num_distinct statistics to settle on a plan the is best for most.

At 02:43 AM 5/8/2007, fairlie rego wrote:
>Hi,
>
>I am at a site which is a high intensive OLTP site doing more than
>400 txns/sec on a 8 node cluster on 10.1.0.5 RAC. We are thinking of
>switching off bind variable peeking and looking into an optimal
>value of dynamic sampling since we have plans flipping all the time
>and causing havoc.
>
>I would like to know if there are any other customers who have
>disabled bind variable peeking and what value of dynamic sampling is
>being used by them

Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com



This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email
--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 08 2007 - 09:25:23 CDT

Original text of this message

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