Re: disable bv peeking at the statement level (hint?)

From: Boris Dali <boris_dali_at_yahoo.ca>
Date: 2006-01-13 01:45:41
Message-id: 20060113004541.92398.qmail@web32801.mail.mud.yahoo.com

                               

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 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"
> To:
> 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

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

Received on Fri Jan 13 2006 - 01:45:41 CST