Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle 8i on Solaris 2.6 - memory requirements

Re: Oracle 8i on Solaris 2.6 - memory requirements

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/05/23
Message-ID: <959101853.21507.0.pluto.d4ee154e@news.demon.nl>#1/1

Kenneth C Stahl <BlueSax_at_Unforgettable.com> schreef in berichtnieuws 392AB7AC.F22F0659_at_Unforgettable.com...
> Does anyone have a good rule-of-thumb for estimating how much memory
> would be needed on a Solaris 2.6 server running Oracle 8i? The
> installation manual simply says that 128M is needed to install Oracle,
> but I know that I've read somewhere in the past that there is a way of
> calculating how much memory is needed per a certain number of users.
> Additionally, does this change dependent on whether
> multi-Threaded-Server facilities are used?

Usually you need about 8M per session, and my experience with 8i on NT is 128M is in fact insufficient.
If you are using MTS, the users PGA is going to end up in database cache, so yes, this make a big difference.

Hth,

Sybrand Bakker, Oracle DBA Received on Tue May 23 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US