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
...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
-- //www.freelists.org/webpage/oracle-l