| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Survey: Which Linux desktop would you run a test of Oracle on and why?
I did a side-by-side test of Solaris x86 (probably release 7x or so) and
Windows 2000 about 5 years ago and didn't see much difference. I "split"
a one or two CPU Intel server with 4 internal drives down the middle,
installing Solaris x86 on one half of the first drive and Win2k on the
other. Half of each of the other drives was dedicated to each OS.
I then installed the same release of Oracle8 (or 8i, can't remember) in each OS and created identical databases, spread across the 4 drives. Then I would alternate booting each OS and running some home-grown "stress-testing" scripts against identical tables/indexes in each database. The scripts did massive Selects, Inserts, Updates, and Deletes. Can't remember how many sessions of the scripts I ran in parallel - not that many, probably about 4 or 5.
Anyway, the overall times were so close to the same that it wasn't significant. I do remember that the database under each OS seemed to consistently "favor", say, Inserts over Updates or some such, doing them faster than the other. Don't know if it was the OS or just Oracle's port to that OS.
For stability and flexibility, I sure preferred Solaris x86 to Win2k. I had several Solaris Admins around, so I didn't have to do the support myself. IMHO it would be worth learning to avoid Windows. Now I have several skilled UNIX Admins who keep our HP-UX and Linux servers hummin', so I still get to be just the DBA.
It was a fun little exercise in any case.
Jack C. Applewhite - Database Administrator Austin (Texas) Independent School District 512.414.9715 (wk) / 512.935.5929 (pager)
The devil made me do it the first time, The second time I done it on my own.
"Jesse, Rich" <Rich.Jesse_at_quadtechworld.com>
Sent by: oracle-l-bounce_at_freelists.org
08/10/2005 04:31 PM
Please respond to Rich.Jesse
To: "Mladen Gogala" <mgogala_at_allegientsystems.com>
cc: <oracle-l_at_freelists.org>
Subject: RE: Survey: Which Linux desktop would you run a
test of Oracle on and why?
Hmmmm....hadn't thought of that. I don't think I'd like it as a desktop, but I'm thinking I'd love to try it as a server.
Thanks for the idea!
Rich
-----Original Message-----
From: Mladen Gogala [mailto:mgogala_at_allegientsystems.com]
Sent: Wednesday, August 10, 2005 4:06 PM
To: Jesse, Rich
Cc: oracle-l_at_freelists.org
Subject: Re: Survey: Which Linux desktop would you run a test of Oracle
on and why?
Jesse, Rich wrote:
>
>Ideally, I'd like to get away from the RPM Hell, which significantly
>narrows down the field, but I'm willing to be convinced otherwise.
>
>Thoughts?
>
If you dropped the requirement for 9.2, I'd suggest this distribution:
http://www.sun.com/software/solaris/get.jsp
It's ellegant, proven and stable. A colleague of mine is installing
Solaris x86 on a Dell PC right now. I'll let you
know how are things by the end of the next week. We're planning to
install 10.1.0.3 If anyone has suggestions,
I'm dying to hear them.
-- Mladen Gogala Oracle DBA Ext. 121 -- -- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 10 2005 - 17:30:15 CDT
 |
 |