| Insertion problem in RAC env ... [message #174321] |
Sat, 27 May 2006 12:42  |
anandpatil2
Messages: 3
Registered: May 2006
Location: Bangalore
|
Junior Member |
|
|
Hi,
I have got 2 node in RAC environment.I have got a comman table on which my application on both the nodes will be inserting data.This table has got the seq (oracle sequence) & indexes on some column.
Problem what i'm facing is that my application has become very slow in inserting the data.If i remove the seq (oracle seq) & then it is fast. however removing the index did't increase performance.
My appliacation is so tigthly coupled that i can't keep diff seq.
Is there any way to increase my performance with the same seq?????
I'm new to this RAC env can any one help me out????
|
|
|
|
|
|
| Re: Insertion problem in RAC env ... [message #174668 is a reply to message #174328] |
Tue, 30 May 2006 04:33  |
anandpatil2
Messages: 3
Registered: May 2006
Location: Bangalore
|
Junior Member |
|
|
Hi Mahesh,
I got the solution for the problem. Sequence were defined in noncache.
Now i made it to Cache & increased the number by 200 rather than having default value of 20.
Thanks for the hint
Sorry for the delayed response
Regards
Anand
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
