RE: Urgent rac wait problem

From: Crisler, Jon <Jon.Crisler_at_usi.com>
Date: Mon, 16 Mar 2009 11:10:51 -0400
Message-ID: <56211FD5795F8346A0719FEBC0DB067503F34592_at_mds3aex08.USIEXCHANGE.COM>



You want to make sure that your SGA settings are properly set for each instance. If you are using global SGA settings, it may cause the 2nd smaller node to page excessively and run poorly.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Yechiel Adar Sent: Monday, March 16, 2009 5:50 AM
Cc: ORACLE-L
Subject: Re: Urgent rac wait problem

Since this is the only difference between the servers, I think that the number of cpus and the memory size may be a factor in the optimizer calculations.
In the server with fewer resources oracle choose another path that needed a lot more blocks,
but used less online memory, and caused a lot more gc 2-way wait. I never delved deep into the optimizer.

Adar Yechiel
Rechovot, Israel

Dion Cho wrote:
> You solved your problem by updating the statistics.
>
> Why on the earth do you think that CPU count and physical memory size
> were the reasons?
>
> ================================
> Dion Cho - Oracle Performance Storyteller
>
> http://dioncho.wordpress.com (english)
> http://ukja.tistory.com (korean)
> ================================
>
>

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


--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 16 2009 - 10:10:51 CDT

Original text of this message