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

I'll post a followup here if I ever get an answer.


Mark J. Bobak
Senior Oracle Architect

"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:
> 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 ?
I've spotted many, many other people on asktom asking for the same

Is it possible to have a look at the text of your ER ? - don't think
it's "public".

Alberto Dell'Era
"dulce bellum inexpertis"


Other related posts: