Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ASSM in 10g RAC doesnt seem work that well

Re: ASSM in 10g RAC doesnt seem work that well

From: Christo Kutrovsky <kutrovsky.oracle_at_gmail.com>
Date: Thu, 31 Mar 2005 11:40:02 -0500
Message-ID: <52a152eb05033108405942b562@mail.gmail.com>


Tanel,

is there any statistics that tells me how often it's been stolen ? And any kind of details on the stealing?

It could be very relevant.

Christo

On Wed, 30 Mar 2005 23:53:11 +0100, Tanel P=F5der <tanel.poder.003_at_mail.ee>=  wrote:
> Hi,

>=20

> Sorry I have not followed this thread thoroughly, but you might want to
> experiment manually and set _inst_locking_period and _last_allocation_per=
iod
> to larger values, if the problem comes from instances stealing other
> instances L1 BMBs too often (these parameters should control the time in
> seconds after an instance can steal a L1 bitmap block from other instance=
).
>=20

> If this is not relevant, please ignore..
>=20

> Tanel.
>=20

> ----- Original Message -----
> From: "Christo Kutrovsky" <kutrovsky.oracle_at_gmail.com>
> To: <zoran_martic_at_yahoo.com>
> Cc: "oracle-l" <oracle-l_at_freelists.org>; "Jonathan Lewis"
> <jonathan_at_jlcomp.demon.co.uk>
> Sent: Wednesday, March 30, 2005 10:54 PM
> Subject: Re: ASSM in 10g RAC doesnt seem work that well
>=20

> >I am still interested in this.
> >
> > Martic, sure lets' ignore the waits, but real times speak for
> > themselves. +50% in execution time.
> >
> > And the fact that I've confirmed that L1 block ownership is all from
> > the same instance is very strange. Almost smells like a bug. I can't
> > even begin to imagine the nightmare of trying to explain this to
> > Oracle.
> >
> > --
> > Christo Kutrovsky
> > Database/System Administrator
> > The Pythian Group
> >
> > The Pythian Group
> > On Tue, 29 Mar 2005 10:02:23 -0800 (PST), Martic Zoran
> > <zoran_martic_at_yahoo.com> wrote:
> >> Christo,
> >>
>=20

> --
> http://www.freelists.org/webpage/oracle-l
>=20

--=20
Christo Kutrovsky
Database/System Administrator
The Pythian Group

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 31 2005 - 11:43:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US