Re: gc buffer busy and rac testing
From: Mladen Gogala <mgogala_at_yahoo.com>
Date: Thu, 8 Jan 2009 19:30:30 +0000 (UTC)
Message-ID: <gk5k8m$5sa$1_at_ss408.t-com.hr>
On Thu, 08 Jan 2009 15:07:19 +0100, helter skelter wrote:
Date: Thu, 8 Jan 2009 19:30:30 +0000 (UTC)
Message-ID: <gk5k8m$5sa$1_at_ss408.t-com.hr>
On Thu, 08 Jan 2009 15:07:19 +0100, helter skelter wrote:
> I've done little investigation and I found sql resposible for this
> waits, it's a simple query with join and order, quering two tables. Is
> it normal ?
Yes, it is. The query is probably a report, accessing rather large amount of blocks modified on the other instance. In that case, so called cache fusion mechanism will create consistent image of the blocks modified and ship them over the cluster interconnect to the node executing the query. That takes time. What do you use for the cluster interconnect? I hope it's at least 1G ethernet? 10G would be preferred, but at least 1G is absolutely a must.
-- http://mgogala.freehostia.comReceived on Thu Jan 08 2009 - 13:30:30 CST