RE: How to determine Resource mastering 9i2 RAC
- From: "Hameed, Amir" <Amir.Hameed@xxxxxxxxx>
- To: "K Gopalakrishnan" <kaygopal@xxxxxxxxx>
- Date: Tue, 23 May 2006 09:48:43 -0400
Thanks Gopal.
So, due to the fact that V$GC_ELEMENT is based on X$LE and V$DLM_RESS
(OPS) is now known as V$GE_RESOURCE (RAC) and is based on X$LE,
therefore, somehow this information can be extracted from V$GC_ELEMENT
and V$GE_RESOURCE?
In my opinion, Oracle should do a better job in documenting these things
so that those who don't have access to Oracle's internal sites (like
most of us) can get this information relatively easily.
Amir
-----Original Message-----
From: K Gopalakrishnan [mailto:kaygopal@xxxxxxxxx]
Sent: Tuesday, May 23, 2006 1:14 AM
To: Hameed, Amir
Cc: oracle-l@xxxxxxxxxxxxx; racdba@xxxxxxxxxxxxx
Subject: Re: How to determine Resource mastering 9i2 RAC
Amir,
I am discusing the very same issue in my upcoming RAC book. Basically to
understand the master of the block, you need to convert the
block/buffer name to a to the resource name (combination of X$LE,
DLM_RES , GC_ELEMENT and X$KJBR).
BTW Dynamic Remastering not enabled by default in 9iR2 and it is not
totally functional. For that matter, even in 10gR1 it is not a true
dynamic remastering as it masters the files to the instance and not the
objects. Only 10gR2 has the object level dynamic remastering and for
testing purpose you can manually remaster the objects using the oradebug
lkdebug commands.
-Gopal
On 5/22/06, Hameed, Amir <Amir.Hameed@xxxxxxxxx> wrote:
> Folks,
> Is there a way to find out what instance has mastered a certain block
> in
> 9i2 RAC?
>
> Thanks
> Amir
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts: