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

  • From: "Charles Schultz" <sacrophyte@xxxxxxxxx>
  • To: "Wolfgang Breitling" <breitliw@xxxxxxxxxxxxx>
  • Date: Tue, 12 Sep 2006 20:31:02 -0500

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

On 9/12/06, Wolfgang Breitling <breitliw@xxxxxxxxxxxxx> 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@xxxxxxxxx>:

> 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

Other related posts: