RAC is slower than non-RAC for batch job with lots of update/delete?

From: "qihua wu" <staywithpin@xxxxxxxxx>
To: oracle-l <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 18 Oct 2007 18:03:01 +0800

Hi, everyone,

After our database changed into RAC enviroment, the batch job is very slow.
I am wondering whether RAC is not good for batch job. As batch job only use
one session and only connect to one instance, but when update/delete data,
sometime "gc current request" wait occurs as the block must be read from the
other node. Without RAC, then this kind of wait will gone, so I think RAC is
not good for batch job with plenty of update/delete operations. Anyone
doesn't agree?

Thanks,
Qihua

Follow-Ups:

Re: RAC is slower than non-RAC for batch job with lots of update/delete?
From: LS Cheng

Re: RAC is slower than non-RAC for batch job with lots of update/delete?
From: Charles Schultz

RAC is slower than non-RAC for batch job with lots of update/delete?

Other related posts: