Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Job taking longer with more RAC nodes

RE: Job taking longer with more RAC nodes

From: Hameed, Amir <Amir.Hameed_at_xerox.com>
Date: Thu, 9 Mar 2006 16:53:32 -0500
Message-ID: <77A4D80DB2ADD74EB5D7F1D31626F0C0032178A9@usa0300ms03.na.xerox.net>


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_at_yahoo.com] Sent: Thursday, March 09, 2006 4:35 PM
To: Hameed, Amir; oracle-l_at_freelists.org; racdba-bounce_at_freelists.org 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

> 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
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 09 2006 - 15:53:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US