RE: Job taking longer with more RAC nodes
- From: "Hameed, Amir" <Amir.Hameed@xxxxxxxxx>
- To: "john d parker" <orclwzrd@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>, <racdba-bounce@xxxxxxxxxxxxx>
- Date: Thu, 9 Mar 2006 16:53:32 -0500
This is an Oracle 11i application 11.5.9) and the database version is
9.2.0.6 (64-bit). The thing that is surprising me is that there are no
RAC specific waits. It is the CPU usage that is going high. I am sure
there is an explanation to this and that is what I am trying to find
out.
-----Original Message-----
From: john d parker [mailto:orclwzrd@xxxxxxxxx]
Sent: Thursday, March 09, 2006 4:35 PM
To: Hameed, Amir; oracle-l@xxxxxxxxxxxxx; racdba-bounce@xxxxxxxxxxxxx
Subject: Re: Job taking longer with more RAC nodes
Do you have any degree of parallelism? or is parallel degree set to
default?
In general, A well behaved app will perform approx the same on RAC maybe
even marginally slower. A poorly behaved app will absolutely stink when
moved to RAC. RAC is not a performance enhancing solution.
John
--- "Hameed, Amir" <Amir.Hameed@xxxxxxxxx> wrote:
> Folks,
> I need some help in understanding why a job is taking longer when it
> is run in multiple nodes under RAC versus a single node in RAC and
> with RAC disabled.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
