Indeed. We scrapped an Sybase to Oracle conversion in 2006 because of performance issues around case insensitivity.
This e-mail and its attachments are confidential and solely for the intended addressee(s). Do not share or use them without Fannie Mae's approval. If received in error, contact the sender and delete them. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shyam Attavar Sent: Tuesday, July 01, 2008 12:59 PM To: arslist@ARSLIST.ORG Subject: Re: Oracle 10G R2 - Case Sensitivity - ITSM 7 Phil, I am not sure if you are aware of the performance impact a case insensitive Oracle DB can have on the overall application performance. I have heard at least couple of scenarios where people were forced to revert back to a case sensitive setup, when performance issues became unbearable. Hope you have considered this. Regards, -- Shyam ----- Original Message ----- From: "Boucher, Philip" <[EMAIL PROTECTED]> Newsgroups: gmane.comp.crm.arsystem.general To: <arslist@ARSLIST.ORG> Sent: Tuesday, July 01, 2008 8:33 AM Subject: Oracle 10G R2 - Case Sensitivity - ITSM 7 Hi, We are currently setting up a new ARS 7.1 - ITSM 7 system on an Oracle 10G R2 database and will require the database to be case insensitive. I've read several posts on here about Oracle and case sensitivity but I'm not clear on exactly what needs to be done. I've found that the following session variables need to be set: ALTER SESSION SET NLS_SORT=BINARY_CI ALTER SESSION SET NLS_COMP=LINGUISTIC But do we need to do anything else such as creating additional indexes? Also can we make these changes after the initial set up or do they need to be applied before the installation begins. If anyone else has done this recently I'd really like to hear their experiences. Thanks Phil Boucher Remedy Technical Architect _____________________________ Logica - Releasing your potential 400 Park Avenue, Aztec West Almondsbury Bristol BS32 4TR UK T: +44 (0) 1179 017661 (direct) E: [EMAIL PROTECTED] www.logica.com Logica UK Limited Registered in England and Wales (registered number 947968) Registered office: Stephenson House, 75 Hampstead Road, London NW1 2PL, United Kingdom This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you. ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
