Dynamic remastering is ability to move the ownership of resource from one instance to another instance in RAC. dynamic resource remasterin...
Dynamic remastering is ability to move the ownership of resource from one instance to another instance in RAC. dynamic resource remastering is used to implement for resource affinity for increased performance. resource affinity optimized the system in situation where update transactions are being executed in one instance. when activity shift to another instance the resource affinity correspondingly moves to another instance. If activity is not localized, then resource ownership is hashed to the instance.
In 10g dynamic remastering happens in file +object level. the process of remastering is very stringent. For one instance should touch more than 50 times than the other instance in particular period (say 10 mints). this touch ratio and time can be tuned by gc_affinity_limit and _gc_affinity_time parameter.
