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

Too little for real analysis, BUT a very quick diagnostic to possibly point the finger at the RAC part of the configuration is to shut off all but one instance of the RAC. If things then get faster, you probably have something wrong with your RAC configuration (a common silly thing is having ethernet and gigabit net and specifying the ips so you use the slow network or some bad pathway.)

Regards,

mwf

-----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    development PCs, early build is given to customer for "look and    feel" and training purposes.

Sad facts:

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

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

Question:

   If you were really incompetent SA/DBA what would be easy ways    to duplicate the above requirement? (achieve five times    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.

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. Still curiosity factor is strong - what could possibly be so wrong with this RAC?

Wild guesses - welcomed :-)

Branimir

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


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