Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RAC is slower than non-RAC for batch job with lots of update/delete?
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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 18 2007 - 05:03:01 CDT
![]() |
![]() |