| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Bind Variable Substitution In Exec Plan
is it possible that the optimizer is peeking into the bind variable and
then incorrectly deciding
on which table to drive with first?
You can set the optimizer_features_enable to '8.1.7' (before bind
peeking existed)or
you can set "_optim_peek_user_binds" = false at the session level to
see if that prevents
oracle from driving with the wrong table. .. I'm not sure if either
option can be easily implemented
in the siebel environment though...
--peter Received on Thu Nov 17 2005 - 15:21:40 CST
 |
 |