Re: 10g RAC and defined services performance problem
Date: Thu, 11 Sep 2008 09:56:46 -0500
I cant think of any reason why the services per-se could be the problem. However, it is not that unusual for applications not to scale well across multiple nodes. Did you do any analysis to try and partition the workload across the nodes so that each node would access a different subset of data?
On Thu, Sep 11, 2008 at 9:51 AM, Crisler, Jon <Jon.Crisler_at_usi.com> wrote:
> We have a 3-node 10.2.0.3 RAC Server on Red Hat 4, and have defined about
> 20 additional services with preferred nodes set to 1 specific node, with
> available nodes set for the other 2 nodes. Workload is divided evenly with
> about 7 services on each node. Has anybody run into specific problems with
> performance when using a lot of services, as opposed to having the
> application just connect to the main db load-balanced service ?
> This particular application has a reputation from the developers of not
> scaling well across RAC nodes, and we have recently been advised of a lot of
> performance problems that I am now starting to investigate, but I want to
> get some opinions on the wisdom of using many different services rather than
> just a few or one.
-- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' -- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 11 2008 - 09:56:46 CDT