Does added this to the ar.conf file speed up process from a users perspective as well, querying the DB, creating tickets etc....
Kevin Begosh, RSP Tech Ops Enterprise Business Services 301-791-3540 Phone 410-422-3623 Cell [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow Sent: Thursday, November 20, 2008 3:15 PM To: arslist@ARSLIST.ORG Subject: Re: Oracle Cursor Sharing in ARS7.1 ** You have to do it on the database server as well - and they need to match. I believe the file is init.ora but your DBA will know. You might also want to put your servers in development cache mode if you are not in production yet. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Chowdhury, Tauf Sent: Thursday, November 20, 2008 1:36 PM To: arslist@ARSLIST.ORG Subject: Oracle Cursor Sharing in ARS7.1 ** All, I am running a server group with 2 AR Servers. I have noticed that saving changes or new objects within the Admin tool takes a long time... 5-7 minutes in some instances. I've seen the article regarding entering the string into the config file: Oracle-Cursor-Sharing: FORCE Are there any hidden side effects any of you have seen from this that may affect other modules? I currently have ITSM 7.0.3 and CMDB 2 with RKM, SLM, SRM in the pipeline. Any feedback would be appreciated. Thanks. Tauf Chowdhury | Forest Laboratories, Inc. Sr. Analyst Informatics Office: 631.858.7765 Mobile:646.483.2779 ________________________________ This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"