Word of Caution on an Oracle RAC ... make sure you allocate a lot of memory to the db. Here is what remedy recommends:
Small DB: CPU 2 Memory 4 Gig Concurrent Users 1-400 sga_target 1-2 gigs pga_aggregate-target 1 gig Medium DB: CPU 4 Memory 8 Gig Concurrent Users 401-800 sga_target 3-4 gigs pga_aggregate-target 2 gig Large DB: CPU 8 Memory 16 Gig Concurrent Users 800 or more sga_target 6-8 gigs pga_aggregate-target 2-4 gig (page 18 on the Performance Tuning for Business Service Management Document) One problem we ran into with RAC: 4 servers x 1 gig of memory is not equal to 1 server X 4 gigs of memory. The more memory you allocate to the DB the better your performance. So if your remedy db is shared among other databases on the same server you may not be able to allocate a whole lot of memory to the db. Something to keep in mind. Thanks, Sean From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of W Scott Russell Sent: Monday, November 17, 2008 9:16 AM To: arslist@ARSLIST.ORG Subject: Re: Load Balanced Remedy -> Load Balanced Oracle environments? ** Dave, It will work given the right DBA help and experience. And the right appliction tuning. We are running a 4 node Oracle 10g RAC with 20+ ARS (7.1) processing over 100,000+ tickets a day. Scott On Fri, Nov 14, 2008 at 3:41 AM, Barber, David <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>> wrote: ** Shyam, I think the question for us is whether going Oracle RAC will give us scalability. From what Conny said it sounds as if we'd probably have a performance drop, as we are primarily read/write/modify. I've discussed this with our DBA, and he's done some investigation, and it turns out that Remedy is not truly Oracle RAC aware. This could also explain why I've had one of the developers ask if I've seen anything about Remedy 7.5 (hoping that its RAC aware???). Ta Dave -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG>]On Behalf Of Shyam Attavar Sent: 14 November 2008 07:05 To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Subject: Re: Load Balanced Remedy -> Load Balanced Oracle environments? ** We are also running Oracle 10gR2 (RAC) on a RHEL (Red Hat Enterprise Linux) cluster with three nodes. Not sure if this directly equates as Load Balanced Oracle environment. We have been on this setup for over a year and we have not seen any real issues so far. HTH -- Shyam ----- Original Message ----- From: Barber, David<mailto:[EMAIL PROTECTED]> Newsgroups: gmane.comp.crm.arsystem.general To: arslist@ARSLIST.ORG<mailto:arslist@ARSLIST.ORG> Sent: Thursday, November 13, 2008 7:59 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<http://www.rmsportal.com/> ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com<http://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<http://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"