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