RE: Bind variable peeking and Dynamic sampling
- From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
- To: <Brandon.Allen@xxxxxxxxxxx>
- Date: Tue, 8 May 2007 21:12:17 +0200
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
