Okay, thanks. I trust your think more than my think on this thing. :-) Thad
On Fri, Dec 3, 2010 at 11:24 AM, Axton <[email protected]> wrote: > ** 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"_ >> > > _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"
