RE: Bind variable peeking and Dynamic sampling

Hi Brandon

> I've filed enhancement request 6030306 to add a hint or some other
> method of forcing Oracle to always hard-parse and bind-peek for
> certain queries.  If any of you agree this would be a good
> enhancement, please submit an enhancement request of your own
> and reference the above ER number and if enough of us ask for it,
> hopefully they'll add it soon.

FWIW a new plan stability feature that will be introduced in 11g should
solve such problems. Sorry, I cannot provide more details because of
NDA.

More generally, IMHO, no hints should be provided for such problems. The
query optimizer should be able to handle them.


Cheers,
Chris
--
http://www.freelists.org/webpage/oracle-l

Other related posts: