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

  • From: "LS Cheng" <exriscer@xxxxxxxxx>
  • To: staywithpin@xxxxxxxxx
  • Date: Thu, 18 Oct 2007 13:07:22 +0200

have you traced the job

thanks

--
LSC


On 10/18/07, qihua wu <staywithpin@xxxxxxxxx> 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
>

Other related posts: