Charlie,
You are hardly able to fit two instances of your configuration into 256M
along with OS memory requirements. For example, JServer option has
additional requirements for java_pool_size. RTFM about OLAP and Data Mining
option if they have some additional memory requirements. Partitionning AFAIK
doesn't.
32M for 9i SGA - probably impossible or you database will not function
properly.
The full formula for the total memory requirement of the Oracle9i on
unixbackground processes may be found in "Oracle9i Administrator's
Reference" for 9.0.1 Part No. A90347-02 and page 1-14 "Oracle9i Memory
Requirements".
It looks like
text + SGA + (n * (data + uninitialized_data + 8192 + 2048) )
see the manual for details. Of course, the SGA is the biggest part when
there are few users.
--
hth
Alexandre
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, June 25, 2002 12:05 AM
> Yes, I know I need to RTFM, but if some kine soul has a quick
> answer for me, I'd appreciate it.
>
> > startup
> ORACLE instance started.
>
> Total System Global Area 168788768 bytes
> Fixed Size 729888 bytes
> Variable Size 100663296 bytes
> Database Buffers 33554432 bytes
> Redo Buffers 33841152 bytes
> Database mounted.
> Database opened.
> > exit
> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit
Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.1.0 - Production
> oracle@actaeon:CAN#
>
>
> I just got done upgrading two V7.3.4.5 instances to V9.2 on a sandbox
> which has only 256MB RAM. Both SGAs are currently sized the same way.
> The OS is paging/swapping like carzy because SGA1+SGA2>256MB. :-(
>
> Which initSGA.ora parameters control the "Variable Size" piece of
> the 9i SGA? I'd like to shrink this total to around 32MB.
>
> TIA & HAND!
>
> --
> Charlie Mengler Maintenance Warehouse
> [EMAIL PROTECTED] 10641 Scripps Summit Ct.
> 858-831-2229 The Micro$oft Haiku Creed San Diego, CA 92131
> Chaos reigns within. Reflect, repent, and reboot. Order shall return.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Charlie Mengler
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alexandre Gorbatchev
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
