RE: [OT] HOWTO's of messing up Linux cluster?
- From: "Hostetter, Jay M" <JHostetter@xxxxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 22 Nov 2004 08:29:49 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Branimir Petrovic
Sent: Saturday, November 20, 2004 6:30 PM
To: 'oracle-l@xxxxxxxxxxxxx'
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
--
//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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
