Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RAC is slower than non-RAC for batch job with lots of update/delete?

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

From: qihua wu <staywithpin_at_gmail.com>
Date: Thu, 18 Oct 2007 18:03:01 +0800
Message-ID: <2689c1070710180303o63ddfd91tf7d77bf9e42a05f5@mail.gmail.com>


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
Received on Thu Oct 18 2007 - 05:03:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US