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

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

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