This is very much a shot in the dark, but look closely at your library hit ratio. A common cause of high cpu is non-reusable sql On Thu, Sep 11, 2008 at 10:07 AM, Crisler, Jon <Jon.Crisler@xxxxxxx> wrote: > 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.' > -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.'