Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: "No bind buffers allocated" and "_optim_peek_user_binds = true"

RE: "No bind buffers allocated" and "_optim_peek_user_binds = true"

From: <Joel.Patterson_at_crowley.com>
Date: Wed, 13 Sep 2006 14:24:18 -0400
Message-ID: <02C2FA1C9961934BB6D16DE35707B27B020540AB@jax-mbh-01.jax.crowley.com>


This does sound similar to what my developer is talking about... the _optim_peek_user_binds is hidden no? I've never used it.  

My statistics_level is typical. And the version is 10.2.0.1  

Joel Patterson
Database Administrator
joel.patterson_at_crowley.com
x72542
904 727-2542


From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Charles Schultz Sent: Wednesday, September 13, 2006 9:46 AM To: Wolfgang Breitling
Cc: Oracle-L Freelists
Subject: Re: "No bind buffers allocated" and "_optim_peek_user_binds = true"  

I filed a bug with Oracle. Apparently, bind buffers are not peeked when you set statistics_level = ALL in 10.2.0.2. At least, not for my simple tests.

I was using statistics_level = all because it makes Cardinality Feedback so much simpler (query 2 dictionary tables, as opposed to ripping apart 10046 and 10053 traces). So much for that idea....

On 9/12/06, Charles Schultz <sacrophyte_at_gmail.com> wrote:

This is straight pl/sql issued via sqlplus from the command line on the same host.  

On 9/12/06, Wolfgang Breitling < breitliw_at_centrexcc.com <mailto:breitliw_at_centrexcc.com> > wrote:

What is the application which shows that? It is possible to for an application
to issue a parse call without supplying bind values. There was a problem with a
version of JDBC which it didn't send bind info, but I believe that is fixed in
10.2 - assuming the client also has been upgraded to 10.2. Christian Antognini will know more details about this.

Quoting Charles Schultz <sacrophyte_at_gmail.com >:

> Under which circumstances will a bind buffer not be allocated? I was
> diagnosing a 10053 trace and even though it looks like the bind
variables
> should be peeked, I get empty buffers. The query plan seems to reflect
this,

--
regards

Wolfgang Breitling
Oracle 7,8,8i,9i OCP DBA 
Centrex Consulting Corporation
www.centrexcc.com







-- 

Charles Schultz 




-- 
Charles Schultz 


--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 13 2006 - 13:24:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US