Re: Oracle Server System Specs

From: Peter J. Holzer <hjp-usenet_at_hjp.at>
Date: Tue, 11 Feb 2003 22:33:39 +0100
Message-ID: <slrnb4ir1j.4gc.hjp-usenet@teal.hjp.at>

On 2003-02-11 17:11, DA Morgan <damorgan_at_exesolutions.com> wrote:

> Michael Wisenbaker wrote:
>

>> Hahahaha. My brevity indicates that I do not have the answers to your
>> questions, if I had I would have provided that information in the
>> first place. My question should be taken at face value. I wasn't
>> looking for an exact answer, simply wondering what experiences others
>> had with Oracle. Nor was I looking for advice on what my company
>> should to in order to manage this "properly". I work for an
>> institution of "higher education" and we do not have the funds to hire
>> someone to pursue this full time. So, to reiterate my original
>> question, and provide clarification: What do you run Oracle on?

> 
> And I head the Oracle Application Development Certificate program at the University of Washington so
> your turf is not unfamiliar.

Similar here: Non-commercial computing center mostly working for a non-commercial research institute. Officially, we have half a DBA.

> I run Oracle on Win2K, Solaris, and HP/UX. You can obtain perfectly good working Sun Ultra 5s for about

> $500 and I just purchased another HP 9000 C180 with HP/UX 11 for $80 ... from eBay. Which keeps the
                                    ^^^^^^^^^^^^

That's also about the slowest machine we have running Oracle on: A C160 with 256 MB RAM. Our DBA doesn't like it very much :-)

The "main" database server is also a rather old HP-UX box with 3 200 MHz processors and 1 GB of RAM. It could use another Gig of RAM and faster processors, and will be replaced this year. There are mostly batch jobs on this machine.

We also have two databases on dual Pentium III machines with 1 GB of RAM. One mostly for web stuff (with iAS, Portal and Roxen as frontends) the other with 100+ GB numerical data used in batch jobs. Predictably, the first machine is rather bored, the second could be faster (but that would probably be true no matter how fast the machine was, given that the jobs often run for several days). There is probably still a lot of tuning potential in the latter DB.

All the databases are 8.x, BTW.

-- 
   _  | Peter J. Holzer    | To a database person,
|_|_) | Sysadmin WSR       | every nail looks like a thumb.
| |   | hjp_at_hjp.at         |
__/   | http://www.hjp.at/ |     -- Jamie Zawinski

Received on Tue Feb 11 2003 - 15:33:39 CST