One of the reasons is they couldn't fit into the main release of the
kernel. Also I would consider the 10g code base to actually implement
dynamic re-mastering.
Thanks, -Sudhi.
Thanks KG! Interesting. I just checked in my 9.2.0.6 and 9.2.0.4 databases and parameter _lm_dynamic_remastering is set to FALSE (the default is TRUE). Since this is a hidden parameter and therefore is not meant to be set without Oracle's permission, I wonder why Oracle 9i manuals talk about Dynamic Remastering if it is not available out-of-the box in 9i2. Also, is the reason that it is not available out-of-the-box is because the algorithm in 9i2 is not that effective? Any thoughts...
Thanks Amir -----Original Message----- From: racdba-bounce@xxxxxxxxxxxxx [mailto:racdba-bounce@xxxxxxxxxxxxx] On Behalf Of K Gopalakrishnan Sent: Monday, August 01, 2005 8:56 PM To: racdba@xxxxxxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Subject: 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@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