RE: RAC global cache

From: Oliver Jost <Oliver.Jost_at_ca.fujitsu.com>
Date: Tue, 10 Jun 2008 13:47:40 -0400
Message-ID: <DB508580748FAD4692628A58C4E653F504074F4F@MAIL01.Corp.FC.LOCAL>

Thanks All,

   The question has been answered. As to running in single instance, there is a way to place the database in single instance mode (though not recommended) by using ins_rdbms.mk you can decouple the rac binaries.... but, getting it back may not be so simple.  

Oliver

---

From: Frits Hoogland [mailto:frits.hoogland_at_gmail.com] Sent: Tuesday, June 10, 2008 12:44 AM
To: Oliver Jost
Cc: oracle-l_at_freelists.org
Subject: Re: RAC global cache

All the normal RAC rules apply to a database where cluster_database is set to true. I am not aware of any single instance RAC optimisations
(nor can I think of any reason), which means the normal steps are
followed. Probably the callout on the interconnect is not made, because the RAC cluster knows there is only one instance (every instance has to join the cluster explicitly). I haven't tested this explicitly, though.

This should mean some gc waits can be seen, but because there is only one instance, waits like global cache cr request should be minimal.

Because the 'resource mastering' shifts from two nodes to one node upon bringing down one node/instance, this can result in some waits during the remastering. (this phenomenon can be detected in the alert log, if I'm not mistaken)

frits

On Thu, Jun 5, 2008 at 10:38 PM, Oliver Jost <Oliver.Jost_at_ca.fujitsu.com> wrote:

	Hi All,
	   When I bring down one instance in a 2- node RAC environment

(CRS still up, AMS still up, Solaris 9, Oracle 10.2.0.3) I still see
wait events relative to global cache activity? I'm wondering if anyone might clear this up for me. When a block isn't found in the local cache is LMS still busy checking across the interconnect? Do we still get global cache cr request and global cache cur request waits while the living instance determines whether the request will be fulfilled?          

	Thank you, 
	     Oliver 
	

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

Received on Tue Jun 10 2008 - 12:47:40 CDT