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

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
>
>
>

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