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

Chuck,

> I have heard that the Oracle kernel will keep track of how many times a gc
> request is made, and upon hitting a certain threshold, will remaster a
> particular block (or table?) to the node making a majority of the requests.
> Which makes me wonder. If your batch job is always connecting to a specific
> node, could the blocks be mastered explicitly to that node? I ask that of
> the list.

Yes. The behavior is called Dynamic Resource Mastering. If one object (or set of objects) continuously accessed in one particular node the objects are mastered in that node. Check Chapter 11 (Global Resource Directory) of the 10g RAC Handbook..

There used to be some issues in the past (related to node evictions during DRM) and we turn off the DRM if you are < 10.2.0.3.

-Gopal

-- 
Best Regards,
K Gopalakrishnan
Co-Author: Oracle Wait Interface, Oracle Press 2004
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/

Author: Oracle Database 10g RAC Handbook, Oracle Press 2006
http://www.amazon.com/gp/product/007146509X/
--
http://www.freelists.org/webpage/oracle-l