Sequences and RAC -- Inputs Required

From: <k.sriramkumar_at_iflexsolutions.com>
Date: Tue, 1 Jun 2004 15:04:33 +0530
Message-ID: <10898BE7CA96D611988B000802255AAF068381DC@fmgrt.rt.i-flex.com>

Hi Gurus,  

    We are testing our application(OLTP) in 2 node RAC setup(HP UX 11.11) in 9iR2(9.2.0.4). We are seeing a negative scalability when we move to RAC. Say if we had x TPS in a 4 CPU box, we are seeing only a .6x-.7x when we move to a 2 way 4 CPU box.  

I have checked the basic RAC setup and the setup looks ok.  

Our application relies heavily on sequences and I feel that the sequences could be the one that is causing the problem. I am planning to cache the sequences ( with no order)  

Have any one of you seen better TPS when moved to RAC?? any pointers for achieving better TPS in RAC?

Best Regards

Sriram Kumar  

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Tue Jun 01 2004 - 04:27:41 CDT