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.
