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: Charles Schultz <sacrophyte_at_gmail.com>
Date: Tue, 12 Sep 2006 20:31:02 -0500
Message-ID: <7b8774110609121831u40939678t5e18045bc2238e7d@mail.gmail.com>


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> 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

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 12 2006 - 20:31:02 CDT

Original text of this message

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