Re: Dynamic re-mastering in RAC

Amir:

The right answer to your question is it depends. There is no dynamic remastering in 9i RAC other than in 9204/9205 where the parameter (only) _lm_dynamic_remastering is set to true.

In 10gR1 dynamic remastering is set at file level and starting from R2 the dynamic remastering is done at FILE+OBJECT Level. But conditions are very stringent. For example one instance should touch the blocks (of that object) 50 times more than the other instance in particular period (say 10 mins). These touch ratio and time can be tuned by _gc_affinity_limit and _gc_affinity_time parameters.

Regards,
Gopal

On 8/2/05, Hameed, Amir <Amir.Hameed_at_xerox.com> wrote:
>
>
> Folks,
> Is dynamic re-mastering done at the file-level or at the block level? That
> is, does an instance master the entire datafile or only those blocks that
> were repeatedly accessed from its buffer cache in a certain file? Is there a
> way to identify/tell which file/block is mastered by a certain instance?
>
> Thanks
> Amir

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