-
_optim_peek_user_binds
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.
Jeff Hunter
-
Re: _optim_peek_user_binds
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,12c
email: ocp_9i@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|