RE: Buffer mode and Role in RAC
- From: "Hameed, Amir" <Amir.Hameed@xxxxxxxxx>
- To: <racdba@xxxxxxxxxxxxx>
- Date: Sun, 24 Jul 2005 23:43:23 -0400
x$le.le_mode and x$le.le_role contain information on lock element mode
and lock element role respectively. X$le.le_mode can have the following
possible values:
0 -> Null
3 -> Shared
5 -> Exclusive
Where as x$le.le_role can have the following values:
0 -> Global
1 -> Local
Regards
Amir
-----Original Message-----
From: racdba-bounce@xxxxxxxxxxxxx [mailto:racdba-bounce@xxxxxxxxxxxxx]
On Behalf Of Anand Rao
Sent: Saturday, July 23, 2005 2:31 AM
To: racdba@xxxxxxxxxxxxx
Subject: Re: Buffer mode and Role in RAC
Yep, i would second sudhi's comment...
why are you looking at this information? could you also please
elucidate what *exactly* are you looking for?
Buffer mode and role are two different things. Like Sudhi mentioned,
X$LE is a better bet for role of a buffer and details about the mode
can be seen in X$BH.
regards
anand
On 23/07/05, Hameed, Amir <Amir.Hameed@xxxxxxxxx> wrote:
> Thanks Sudhi,
> I will look into x$le. I need this information from learning and
> validation standpoint. It is one thing to read in Oracle manuals how
the
> mode/role changes take place but I find it more exciting when I can
> demonstrate things to clear my own understanding.
>
> Thanks
> Amir
> -----Original Message-----
> From: racdba-bounce@xxxxxxxxxxxxx [mailto:racdba-bounce@xxxxxxxxxxxxx]
> On Behalf Of Sudheendra Vijayakumar
> Sent: Friday, July 22, 2005 5:26 PM
> To: racdba@xxxxxxxxxxxxx
> Subject: Re: Buffer mode and Role in RAC
>
> I don't have an access to a RAC instance, but you
> might want to check the x$le (lock element) along with
> x$bh. X$le should contain the lock mode of the
> element. Also there should be something like an addr
> with which you can join this to x$bh.
>
> Whether the buffer has a global or local role is
> something which I'm not sure where to look for. Needs
> some digging into structures...
>
> But I'm curious to know why would you need this kind
> of information?
>
> Thanks,
> -Sudhi.
>
> --- K Gopalakrishnan <kaygopal@xxxxxxxxx> wrote:
>
> > Forwarding Amir's message to the distribution list,
> > at it was bounced
> > for some reason. I am looking in to it...-Gopal
> >
> > <begin>
> >
> > Folks,
> > Is there a view (x$ or gv$) that contains
> > information on the mode and
> > role of a data buffer in RAC? The x$bh does not
> > contain this
> > information. Any feedback will be appreciated.
> >
> > Thanks
> > Amir
> >
> > <end>
> >
> >
> > --
> > Best Regards,
> > K Gopalakrishnan
> > Co-Author: Oracle Wait Interface, Oracle Press 2004
> >
> http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/
> >
> >
>
>
>
>
> ____________________________________________________
> Start your day with Yahoo! - make it your home page
> http://www.yahoo.com/r/hs
>
>
>
>
Other related posts:
