RE: Urgent rac wait problem
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-lReceived on Mon Mar 16 2009 - 10:10:51 CDT