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!

Load Balancing with 10g RAC

430762Jul 5 2007 — edited Jul 6 2007

Hi,

I have one query regarding balancing load with RAC.

We have some batch processes executed from shell script in Oracle RAC environment where a separate node is used for failover only. There are some issues related with performance. We are looking for a solution to utilize 'idle' node used for failover to resolve this issue.

I want to know whether the below mentioned scenario is possible to achieve with 10gRel2 RAC.

A batch process is running and it is utilizing all resources (CPU) of instance 1, then it is possible by any means that this process be split and distributed to idle instance 2 on another node?

Looking for expert advice.

Regards
Amit

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 3 2007

Added on Jul 5 2007

#general-database-discussions

8 comments

707 views