"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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Sep 12 2006 - 15:54:54 CDT