Re: Oracle server 8.1.7

That's a little severe, Daniel.

Bearing in mind that the Internet is an
international arena, it's possible that the original poster may have been using a
second language and used the word
'memory' when they were really thinking
'disk space'. In which case I recall that I once recovered around 500MB of disc
by deleting all the excess garbage that
Oracle dumped in the $ORACLE_HOME
when all I wanted was the server executable.

Possibly in migrating a small system from 8.0.6 to 8.1.7 the poster has not noticed that Oracle has introduced a default 20MB memory demand for the Java_Pool_Size.
It is perfectly reasonable to run a small system on 64MB of SGA - in which case
a 20MB increment would be a nuisance.

May I bring to your attention the wise
words of Thumper's father -

"If you can't say anything nice, don't
say anything at all."

Though I think in the arena of an
educational environment (such as
a technical usenet newsgroup) this
should perhaps be modified to:

"If you have to say something nasty,
try and say it nicely".

Your post contains one important hint,
however, but lacks suitable precision:

> Go into the instance's initSID.ora file and put in the
> smallest parameters you can.

If you have no use for Java, set java_pool_size = 65536

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison-Wesley

Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Daniel A. Morgan wrote in message <3B2949C4.8EB32ABB_at_exesolutions.com>...


>Michael wrote:

>

>> Has anyone any experience in stripping down 8.1.7 so that it takes less

>> memory or something close to 8.0.6. What methods can I use?

>>

>> Thanks

>

>In other words you want to gut the performance? Interesting.

>

>Do you understand how Oracle uses memory? Have you evaluated memory needs

>based on some criteria taking into account SGA, block buffers, and sort

>area?

>

>What the heck ... Go into the instance's initSID.ora file and put in the

>smallest parameters you can.

>

>No doubt you can make Oracle run as slowly as MS Access. And crash as often

>as any other Windows product.

>

>Daniel A. Morgan

>