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

  • From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 12 Jan 2006 22:55:40 -0000


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




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


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 01-2006