Re: New install of 8i = 275 Meg of Memory!

From: Richard Lloyd <rkl_at_csc.liv.ac.uk>
Date: Mon, 21 Jun 1999 22:37:50 GMT
Message-ID: <FDp872.MKu@csc.liv.ac.uk>

In article <376B6E99.39FF552E_at_value.net>, "Michael P. McCutcheon" <michaelm_at_value.net> writes:
> What is wrong? Does oracle normally require a machine with greater than
> 256mb memory to run?

It depends on the values you've set in your config files (e.g. init<SID>.ora). I *strongly* recommend use of the multi-threaded server on any Oracle server set-up (in fact, it's a little surprising that it isn't all configured in by default - it's commented out in the init<SID>.ora). If you don't use it, you end up with a separate process for every connection, which soon becomes a major resource hog.

The other thing I did was to convert most of the archive libraries (.a) to shared libraries (.sl or .so depending on your platform) and then relinked all the executables against the shared libraries. Brought most of the binaries down to 25% or less of their original size and saved a ton of RAM. Gawd knows why Oracle only shipped about 6 shared libraries with 8.0.5 (may be more with 8i, I haven't seen this year) and about 100 archive libraries !

Having said all of this, we do still have 512MB RAM on our Oracle server machine - you can never have too much RAM on a database server !

Richard K. Lloyd,         E-mail: rkl_at_connect.org.uk
Connect,                     WWW: http://www.connect.org.uk/

Liverpool University,
Merseyside, England,
Great Britain. Received on Mon Jun 21 1999 - 17:37:50 CDT