Home » Server Options » RAC & Failsafe » Insertion problem in RAC env ...
Insertion problem in RAC env ... [message #174321] Sat, 27 May 2006 12:42 Go to next message
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 #174328 is a reply to message #174321] Sat, 27 May 2006 15:01 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Are the sequences defined with NOCACHE?
What is the freelist value for the concerned table?
Re: Insertion problem in RAC env ... [message #174668 is a reply to message #174328] Tue, 30 May 2006 04:33 Go to previous message
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
Previous Topic: non rac database in 10g on rac server
Next Topic: 10g RAC instance order
Goto Forum:
  


Current Time: Thu Dec 02 22:56:59 CST 2021