DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: _optim_peek_user_binds

  1. #1
    Join Date
    Nov 2000


    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
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  2. #2
    Join Date
    Jun 2001
    Helsinki. Finland

    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

Click Here to Expand Forum to Full Width