With the clusterware you can setup a service for every schema which can fail over to another instance. Frits Hoogland http://fritshoogland.wordpress.com mailto:frits.hoogland@xxxxxxxxx <frits.hoogland@xxxxxxxxx> cell: +31 6 53569942 Op 6 aug. 2011 om 08:22 heeft Toon Koppelaars <toon.koppelaars@xxxxxxxxxxx> het volgende geschreven: I think you've answered that design question very wisely. On Sat, Aug 6, 2011 at 12:49 AM, Walker, Jed S <Jed_Walker@xxxxxxxxxxxxxxxxx > wrote: > Hi,**** > > ** ** > > I’m new to RAC, but have a question. We have a 5 node RAC that supports > multiple markets each of which has its own schema. Due to each market having > its own schema, there is no sharing of blocks between markets. As such, I am > thinking that it would make sense to have each market work on only one node > because that would avoid having blocks passed between nodes, and thus should > be good for performance. (Note: the intent behind RAC was for high > availability, not for scaling, each node can handle the workload of multiple > markets).**** > > ** ** > > Thoughts?**** > > ** ** > > **- **Jed**** > > ** ** > -- Toon Koppelaars RuleGen BV Toon.Koppelaars@xxxxxxxxxxx www.RuleGen.com TheHelsinkiDeclaration.blogspot.com (co)Author: "Applied Mathematics for Database Professionals" www.rulegen.com/am4dp-backcover-text