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

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@xxxxxxx>=
 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@xxxxxxxxx>
> To: <zoran_martic@xxxxxxxxx>
> Cc: "oracle-l" <oracle-l@xxxxxxxxxxxxx>; "Jonathan Lewis"
> <jonathan@xxxxxxxxxxxxxxxxxx>
> 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@xxxxxxxxx> 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

Other related posts: