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

Thread: _optim_peek_user_binds

  1. #1
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    _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

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    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