RE: Bind variable peeking and Dynamic sampling
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>, <greg@xxxxxxxxxxxxxxxxxx>, "Oracle-L" <oracle-l@xxxxxxxxxxxxx>, <fairlie_r@xxxxxxxxx>
- Date: Tue, 8 May 2007 12:50:45 -0700
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@xxxxxxxxxxxxxxx]
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
