Re: Urgent rac wait problem
From: Yechiel Adar <adar666_at_inter.net.il>
Date: Mon, 16 Mar 2009 11:50:00 +0200
Message-id: <49BE20C8.6050507_at_inter.net.il>
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.
Date: Mon, 16 Mar 2009 11:50:00 +0200
Message-id: <49BE20C8.6050507_at_inter.net.il>
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-lReceived on Mon Mar 16 2009 - 04:50:00 CDT