RE: 10g RAC and defined services performance problem
- From: "Crisler, Jon" <Jon.Crisler@xxxxxxx>
- To: "Andrew Kerber" <andrew.kerber@xxxxxxxxx>
- Date: Thu, 11 Sep 2008 11:07:08 -0400
Good question- in fact we did do that- each service runs the same
application, but accesses different schemas; this way a particular
schema would be located on one node. In previous tests the cluster
seemed to work quite well, but now that they are live we are getting
high cpu utilization. We have all the normal tricks in place for
performance tuning- large SGA, fast disks, gige RAC interconnect with
bonding etc. Since I have not been told about the time periods that it
tends to choke I have not been able to do much with AWR etc but I am
trying to get that info.
________________________________
From: Andrew Kerber [mailto:andrew.kerber@xxxxxxxxx]
Sent: Thursday, September 11, 2008 10:57 AM
To: Crisler, Jon
Cc: oracle-l; oracle-rac@xxxxxxxxxxxxx
Subject: Re: 10g RAC and defined services performance problem
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@xxxxxxx>
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.'
Other related posts:
