Does anybody have any experience with the init.ora parameter "_optim_peek_user_binds" on 9.2? We're getting some funky plans on certain statements that are obviously using the wrong plan. When we flush the shared_pool and reexecute the SQL, the plan goes back to what it should be. We are thinking it's because of the bind variable peeking with 9i, and want to turn it off to see if it helps. Note, we're NOT using cursor_sharing=FORCE.
You might want to set _optim_peek_user_binds to off. Usually, this is done on SAP systems.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g
Click Here to Expand Forum to Full Width