Resource affinity allows the resource mastering of the frequently used resources on its local node, it uses dynamic resource mastering to move the location of the resource masters. Normally resource mastering only happens when a instance joins or leaves the RAC environment, as of Oracle 10g R2 mastering occurs at the object level which helps fine-grained object remastering. There are a number of parameters that can be used to dynamically remaster an object
|_gc_affinity_time||specifies interval minutes for remastering|
|_gc_affinity_limit||defines the number of times a instance access the resource before remastering, setting to 0 disable remastering|
|_gc_affinity_minimum||defines the minimum number of times a instance access the resource before remastering|
|_lm_file_affinity||disables dynamic remastering for the objects belonging to those files|
|_lm_dynamic_remastering||enable or disable remastering|
You should consult Oracle before changing any of the above parameters.