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

have you traced the job

thanks

--
LSC


On 10/18/07, qihua wu <staywithpin_at_gmail.com> wrote:


>

> 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-l