Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004
    Posts
    19

    Unanswered: cursor_sharing parameter

    hello I have a dude
    This parameter has default value in my database EXACT.
    We are programmed with bind variable.

    will I have better performance if cursor_sharing=SIMILAR or FORCE?
    Can anybody help me?
    Thanks a lot¡

  2. #2
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    If you are using bind variables then stick with EXACT, you will probably see very slight performance degradation with the others as they have to do more work searching for literals. Also you can get slightly better execution plans with EXACT. The other thing is that SIMILAR or FORCE can cause some strange behaviour in exceptional circumstances.

    Alan
    Last edited by AlanP; 11-05-04 at 08:31.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •