Sequences and RAC -- Inputs Required

From: <k.sriramkumar@xxxxxxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 1 Jun 2004 15:04:33 +0530

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

Follow-Ups:

Re: Sequences and RAC -- Inputs Required
From: Jonathan Lewis

Sequences and RAC -- Inputs Required

Other related posts: