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

Hi,

Sorry I have not followed this thread thoroughly, but you might want to 
experiment manually and set _inst_locking_period and _last_allocation_period 
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).

If this is not relevant, please ignore..

Tanel.

----- 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


>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,
>>

--
http://www.freelists.org/webpage/oracle-l

Other related posts: