RE: [OT] HOWTO's of messing up Linux cluster?

  I'll put my money on the optimizer. Have you checked explain plans and statistics between the two systems?

Jay

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Branimir Petrovic Sent: Saturday, November 20, 2004 6:30 PM To: 'oracle-l_at_freelists.org'
Subject: [OT] HOWTO's of messing up Linux cluster?

Situation:

   Early stages of development project; same small database runs on=20    development PCs, early build is given to customer for "look and    feel" and training purposes.

Sad facts:=20

   "PC Vulgaris" (P4 @ 2.8 GHz with _one_ IDE drive running WinXP)=20    /w Oracle 9.2 db outperforms by factor of FIVE (meaning exact same=20    batch jobs run at least 5 TIMES FASTER!!!???) two node Oracle 9.2=20    cluster on Linux (RH AS3). Beats it by huge margin it every single    time.=20

   Hardware at customer's site is 6 month old (implying relatively=20    new hardware) 2 P4-Xeon CPUs server forming two node Oracle 9.2=20    cluster connected to dedicated (this cluster only, dedicated    to this project only) SAN (with unknown number of drives).=20

Question:

   If you were really incompetent SA/DBA what would be easy ways    to duplicate the above requirement? (achieve five times=20    worse performance using much "stronger" hardware)

>From whatever little I know of ways problematic database is set up and
configured, I'd say it is not the Oracle that is messed up, but the underlying OS.=20

Being at arms length from the problem (due to mountains of political bs. - "us" vs. "them"), and quite frankly due to my own shortcomings with Unix/Linux, I am in no position to help in any meaningful way.=20 Still curiosity factor is strong - what could possibly be so wrong with this RAC?=20

Wild guesses - welcomed :-)

Branimir

--
http://www.freelists.org/webpage/oracle-l





**DISCLAIMER
This e-mail message and any files transmitted with it are intended for the =
use of the individual or entity to which they are addressed and may contain=
 information that is privileged, proprietary and confidential. If you are n=
ot the intended recipient, you may not use, copy or disclose to anyone the =
message or any information contained in the message. If you have received t=
his communication in error, please notify the sender and delete this e-mail=
 message. The contents do not represent the opinion of D&E except to the ex=
tent that it relates to their official business.
--
http://www.freelists.org/webpage/oracle-l