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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Alberto Dell'Era
Sent: Tuesday, May 08, 2007 2:09 PM
To: Brandon.Allen_at_oneneck.com
Cc: greg_at_structureddata.org; Oracle-L; fairlie_r_at_yahoo.com
Subject: Re: Bind variable peeking and Dynamic sampling

On 5/8/07, Allen, Brandon <Brandon.Allen_at_oneneck.com> 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