Re: ASSM in 10g RAC doesnt seem work that well
- From: Tanel Põder <tanel.poder.003@xxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 30 Mar 2005 23:53:11 +0100
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,
>>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
