Re: Dynamic re-mastering in RAC
- From: K Gopalakrishnan <kaygopal@xxxxxxxxx>
- To: racdba@xxxxxxxxxxxxx
- Date: Tue, 2 Aug 2005 06:26:08 +0530
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@xxxxxxxxx> 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/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
