Re: disable bv peeking at the statement level (hint?)
- From: Boris Dali <boris_dali@xxxxxxxx>
- To: Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>
- Date: Thu, 12 Jan 2006 19:45:41 -0500 (EST)
Not in production yet, but development team approached
us with this question after testing their application
with and without bind variable peeking and concluding
that there are (actually only) two statements that
would benefit from using composite stats in favor of
partition ones. So naturally next quesion was whether
or not there is (or there will be) a way to deal with
this at the statement level.
Thanks for the information, Jonathan.
Boris Dali.
--- Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>
wrote:
>
> In 10.2 there is an undocumented hint (one of
> dozens)
> opt_param(parameter_name , value)
> that could be used to set the _optim_peek_user_binds
> parameter to false - but that probably isn't
> something
> you should do on production system; then again, I
> guess you are already doing that at the
> system/session
> level.
>
>
> Regards
>
> Jonathan Lewis
>
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
> The Co-operative Oracle Users' FAQ
>
> http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
> Cost Based Oracle: Fundamentals
>
> http://www.jlcomp.demon.co.uk/appearances.html
> Public Appearances - schedule updated 10th Jan 2006
>
> ----- Original Message -----
> From: "Boris Dali" <boris_dali@xxxxxxxx>
> To: <oracle-l@xxxxxxxxxxxxx>
> Sent: Thursday, January 12, 2006 3:00 PM
> Subject: disable bv peeking at the statement level
> (hint?)
>
>
> > ...can be done at the system/session level, but is
> > there a way to to do that for a specific
> statement?
> >
> > Oracle 9.2.0.6/7 (but would be interesting to know
> for
> > 10g as well)
> >
> > Thanks,
> > Boris Dali.
__________________________________________________________
Find your next car at http://autos.yahoo.ca
--
//www.freelists.org/webpage/oracle-l
Other related posts:
