|
[oracle-l]
||
[Date Prev]
[06-2004 Date Index]
[Date Next]
||
[Thread Prev]
[06-2004 Thread Index]
[Thread Next]
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
|
