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