RE: Bind variable peeking and Dynamic sampling

Yes, true - it wouldn't really have to be a full hard parse, just a re-peek and re-optimization in a new child cursor. It would definitely need to be used sparingly and there would be potential for misuse, but they could make a hidden parameter to disable/enable it and hopefully that would keep the abuse down. I only have one or two queries out of thousands where I would like to use this.

-----Original Message-----
From: Bobak, Mark [mailto:Mark.Bobak_at_il.proquest.com]

I agree that having a hint to selectively hard parse (or, really, just selectively recompute execution plan) would be quite useful. But I suspect Oracle is hesitant to provide it, for fear that it becomes a "magic bullet", and people begin overusing it, causing an overall degradation in performance. It would be great, but would need to be very selectively applied.

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

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