Hi Dave, an Oracle RAC is fine, if your workload is mostly read access. But if you do many creates or modifys then you have locks on the database side. A Distributed Lock Manager must tell the other nodes about that lock. This can be a significant overhead compared to a single node database instance. We've experienced this problem and after switching to only one node the system performed better than before. But this was on Oracle 9i. I don't know if it's better in 10g Kind Regards Conny
________________________________ Von: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Im Auftrag von Barber, David Gesendet: Freitag, 14. November 2008 08:57 An: arslist@ARSLIST.ORG Betreff: Re: Load Balanced Remedy -> Load Balanced Oracle environments? ** The DBA reasoning : that the RAC is normally configured in a failover mode. Haven't spoken to him directly though. It would be a pain if it didn't scale, as we're looking at potentially massive increases in workload - in the next few weeks database utilisation is expected to jump up to around 70%, and we're expecting much bigger leaps in application functionality and users. Many thanks - as a few have said they're running against an Oracle RAC fine, then we'll have to look into configurations. Regards Dave -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Ramey, Anne Sent: 13 November 2008 20:47 To: arslist@ARSLIST.ORG Subject: Re: Load Balanced Remedy -> Load Balanced Oracle environments? ** We are running with an Oracle RAC configuration and it works fine. Anne Ramey *********************************** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Thursday, November 13, 2008 12:54 PM To: arslist@ARSLIST.ORG Subject: Re: Load Balanced Remedy -> Load Balanced Oracle environments? ** Did your DBA give you any reasons why it would not work? Theoretically it should.. All that Remedy requires is a connection string to the database (TWO_TASK if its a remote database - in a cluster this will most definitely be the case). Joe ________________________________ From: "Barber, David" <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Thursday, November 13, 2008 10:59:56 AM Subject: Load Balanced Remedy -> Load Balanced Oracle environments? ** Been asked an intriguing question. Our current Remedy environment : - Hardware load balancer - 2 x ARS 7.0.1 Remedy servers running on Solaris - 1 x Oracle database server running on Solaris Looking to the future and scaling the application, we're looking at load balanced Oracle solutions (I've heard about an Oracle RAC - real application cluster?), and our DBA has stated that Remedy will not work against an Oracle RAC in a load balanced mode. Anyone on the list have experience of running Remedy against a load balanced Oracle cluster? Any case studies, or information to share? Regards Dave Barber This e-mail has been scanned for viruses by the Cable & Wireless e-mail security system - powered by MessageLabs. For more information on a proactive managed e-mail security service, visit http://www.cw.com/uk/emailprotection/ The information contained in this e-mail is confidential and may also be subject to legal privilege. It is intended only for the recipient(s) named above. If you are not named above as a recipient, you must not read, copy, disclose, forward or otherwise use the information contained in this email. If you have received this e-mail in error, please notify the sender (whose contact details are above) immediately by reply e-mail and delete the message and any attachments without retaining any copies. Cable and Wireless plc Registered in England and Wales.Company Number 238525 Registered office: 3rd Floor, 26 Red Lion Square, London WC1R 4HQ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ This e-mail has been scanned for viruses by the Cable & Wireless e-mail security system - powered by MessageLabs. For more information on a proactive managed e-mail security service, visit http://www.cw.com/uk/emailprotection/ The information contained in this e-mail is confidential and may also be subject to legal privilege. It is intended only for the recipient(s) named above. If you are not named above as a recipient, you must not read, copy, disclose, forward or otherwise use the information contained in this email. If you have received this e-mail in error, please notify the sender (whose contact details are above) immediately by reply e-mail and delete the message and any attachments without retaining any copies. Cable and Wireless plc Registered in England and Wales.Company Number 238525 Registered office: 3rd Floor, 26 Red Lion Square, London WC1R 4HQ __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"
