| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle server 8.1.7
Yes - I've often thought about posting a question but my terror of the Pirahnas is too great 8-)
What ever happened to "there's no such thing as a stupid question?"
fdp
Jonathan Lewis wrote:
>
> 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
> >
Received on Fri Jun 15 2001 - 07:28:52 CDT
 |
 |