Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

9i RAC give poor performance compare to single instance database on OpenVMS

647082Jun 25 2008 — edited Jun 30 2008
Hello Dear Friends,

I have successfully installed Oracle 9.2.0.2 RAC(only two instance and two nodes) in HP Alpha OpenVMS 8.2. I'm getting poor performance if two nodes startup compare to only one node startup.

when working on single instance it give me[b] fast response and low cpu utility than working on two instance.

For example, I tested a trigger when insert a table, if only one instance startup, the executive time is about 48s(two much calculation), but if both two instances startup, the time is 89s. why? I can't undestand. In my opinion, I think RAC performance should be much better than single instance, maybe some oracle rac setting or configuration of problems?

so can anybody help me finding out problems of my rac?

Best regards,
Efrain
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 28 2008
Added on Jun 25 2008
6 comments
1,345 views