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 > -- > //www.freelists.org/webpage/oracle-l >=20 --=20 Christo Kutrovsky Database/System Administrator The Pythian Group -- //www.freelists.org/webpage/oracle-l