I'm on 10g and using SIMILAR. I will continue to use it until we upgrade to 11g. I haven't evaluate my options with the later releases of Oracle and I don't know how they will play with Remedy just yet.
Moving from EXACT to either FORCE or SIMILAR will result in some drastic changes, mainly with the memory consumption on the Oracle server. Remedy can't scale very large on Oracle without using the cursor_sharing hack because every single sql statement will require memory and will reside in the pool on the oracle server. The other big advantage to using cursor_sharing is that your hard parses will drop down to a tolerable level on the oracle server. This causes a huge reduction in the cpu overhead on the oracle server. I do not think you will see much of a difference between SIMILAR and FORCE in terms of resource utilization or performance. With the sql that Remedy generates the two settings have nearly the same net effect. I say "do not think" because I don't have any hard numbers to back up the claim. This is just based on my understanding of what that parameter does. On Fri, Dec 3, 2010 at 12:35 PM, Thad Esser <[email protected]> wrote: > ** Axton, > > When we set up our 7.1 servers a couple years ago, I set our cursor sharing > to "similar" based on the BMC white paper: > "Best practices mandate specifically that, with 6.0.1, users should > use force, and *with 6.3 or 7.0, users should use similar*, but the > difference between the two settings is small." > > In the dba-oracle.com link you sent, there's a note: > Note: The cursor_sharing=similar option has been deprecated in Oracle 11g > and will be removed in version 12 per MOSC Note 1169017.1 > > In your opinion (I'm not experienced enough in this area), should I change > the setting on my servers to "force" now, or wait until we need to upgrade > the database (we're on 10g now)? Do you think I'd see any performance > improvements (CMDB2.1 and full ITSM 7.0.3 on ARS 7.1)? > > Thanks, > Thad > > On Fri, Dec 3, 2010 at 9:01 AM, Axton <[email protected]> wrote: > >> ** http://www.dba-oracle.com/t_cursor_sharing.htm >> >> <http://www.dba-oracle.com/t_cursor_sharing.htm>This is something I >> wrote up years ago on the subject: >> >> http://arswiki.org/wiki/Oracle_Performance_Tuning#Cursor_Sharing.2FBind_Variables >> >> >> <http://arswiki.org/wiki/Oracle_Performance_Tuning#Cursor_Sharing.2FBind_Variables> >> Axton >> >> On Fri, Dec 3, 2010 at 10:05 AM, Arshad M <[email protected]> wrote: >> >>> Hi Dave, >>> >>> Thanks for response. >>> >>> My current application is in performance dip, Can any shed some light on >>> cursor sharing? Is this really improves performance? >>> >>> Thanks & Regards >>> >>> Arshad Mahammad >>> >>> >>> >>> >>> >>> >>> "Shellman, David" >>> <dave.shell...@ty >>> COELECTRONICS.COM >>> To >>> > [email protected] >>> Sent by: "Action cc >>> Request System >>> discussion list Subject >>> (ARSList)" Re: test mail >>> <arsl...@arslist. >>> ORG> >>> >>> >>> 3 December 2010 >>> 10:58 AM EST >>> >>> >>> Please respond to >>> [email protected] >>> RG >>> >>> >>> >>> >>> >>> >>> The email was successful. You testing anything else like a response from >>> me? >>> >>> Dave >>> >>> -----Original Message----- >>> From: Action Request System discussion list(ARSList) >>> [mailto:[email protected]] On Behalf Of Arshad M >>> Sent: Friday, December 03, 2010 10:47 AM >>> To: [email protected] >>> Subject: test mail >>> >>> Hello All, >>> >>> This is a test mail. >>> >>> >>> Thanks & Regards >>> >>> Arshad Mahammad >>> >>> >>> >>> This email originates from Steria*. It, and any attachments, may contain >>> confidential information and may be subject to copyright or other >>> intellectual property rights. It is only for the use of the addressee(s). >>> You may not copy, forward, disclose, save or otherwise use it in any way >>> if >>> you are not the addressee(s) or responsible for delivery. >>> If you receive this email by mistake, please advise the sender and cancel >>> it immediately. >>> Steria may monitor the content of emails within its network to ensure >>> compliance with its policies and procedures. >>> Any email is susceptible to alteration and its integrity cannot be >>> assured. >>> Steria shall not be liable if the message is altered, modified, >>> falsified, >>> or edited. >>> _____________________________________________________ >>> * Steria Limited, number 4077975; >>> Steria Recruitment Limited, number 1437998. >>> Registered in England and Wales; registered office Three Cherry Trees >>> Lane, >>> Hemel Hempstead, Hertfordshire HP2 7AH >>> >>> >>> _______________________________________________________________________________ >>> >>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" >>> >>> >>> _______________________________________________________________________________ >>> >>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" >>> >>> >>> >>> This email originates from Steria*. It, and any attachments, may contain >>> confidential information and may be subject to copyright or other >>> intellectual property rights. It is only for the use of the addressee(s). >>> You may not copy, forward, disclose, save or otherwise use it in any way if >>> you are not the addressee(s) or responsible for delivery. >>> If you receive this email by mistake, please advise the sender and cancel >>> it immediately. >>> Steria may monitor the content of emails within its network to ensure >>> compliance with its policies and procedures. >>> Any email is susceptible to alteration and its integrity cannot be >>> assured. Steria shall not be liable if the message is altered, modified, >>> falsified, or edited. >>> _____________________________________________________ >>> * Steria Limited, number 4077975; >>> Steria Recruitment Limited, number 1437998. >>> Registered in England and Wales; registered office Three Cherry Trees >>> Lane, Hemel Hempstead, Hertfordshire HP2 7AH >>> >>> >>> _______________________________________________________________________________ >>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >>> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" >>> >> >> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ >> > > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
