Oracle Database Discussions

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!

query performance on RAC is a lot slower than single instance

641640Aug 6 2009 — edited Aug 11 2009

I simply followed the steps provided by oracle to install a rac db of 2 nodes.
The performce on Insertion (java, thin ojdbc) is pretty much the same compared to a single instance on NFS
However the performance on the select query is very slow compared to single instance.

I have tried using different methods for the storage configuration (asm with raw, ocfs2) but the performance is still slow.

When I shut down one instance, leaving only one instance up, the query performance is very fast (as fast as one single instance)

I am using rhel5 64 bit (16G of physical memory) and oracle 11.1.0.6 with patchset 11.1.0.7

Could someone help me how to debug this problem?

Thanks,
Chau

Edited by: user638637 on Aug 6, 2009 8:31 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 8 2009

Added on Aug 6 2009

#general-database-discussions, #performance, #rac

18 comments

8,752 views