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

  • From: "Charles Schultz" <sacrophyte@xxxxxxxxx>
  • To: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 12 Sep 2006 15:54:54 -0500

Good day, list,

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,
and I am at a loss to explain it. I asked Oracle Support and the only answer
I got back was "this happens sometimes".

This is under 10.2.0.2, so _optim_peek_user_binds defaults to true, and I
have not altered it.

--
Charles Schultz

Other related posts: