RE: Bind variable peeking and Dynamic sampling

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"
--
http://www.freelists.org/webpage/oracle-l


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

Other related posts: