RE: Bind variable peeking and Dynamic sampling
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <alberto.dellera@xxxxxxxxx>, <Brandon.Allen@xxxxxxxxxxx>
- Date: Tue, 8 May 2007 14:51:21 -0400
Heh...well, I filed one, and I must have gotten the same analyst. He
said "I just filed this on Friday. This is the enhancement request
number...." He also claimed I'd be able to view it.
And I replied that I was unable to view it, and asked him to check if it
was publically viewable. So, hopefully, it will soon be publically
viewable.
I'll post a followup here if I ever get an answer.
-Mark
--
Mark J. Bobak
Senior Oracle Architect
ProQuest/CSA
"There are 10 types of people in the world: Those who understand
binary, and those who don't."
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Alberto Dell'Era
Sent: Tuesday, May 08, 2007 2:09 PM
To: Brandon.Allen@xxxxxxxxxxx
Cc: greg@xxxxxxxxxxxxxxxxxx; Oracle-L; fairlie_r@xxxxxxxxx
Subject: Re: Bind variable peeking and Dynamic sampling
On 5/8/07, Allen, Brandon <Brandon.Allen@xxxxxxxxxxx> wrote:
(snip)
> 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.
You mean something like http://tinyurl.com/2fogq9 ?
I've spotted many, many other people on asktom asking for the same
thing.
Is it possible to have a look at the text of your ER ? - don't think
it's "public".
regards
Alberto
--
Alberto Dell'Era
"dulce bellum inexpertis"
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
