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

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: