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
Other related posts:
