| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: V9.2 & SGA
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" <ORACLE-L_at_fatcity.com> Sent: Tuesday, June 25, 2002 12:05 AMReceived on Tue Jun 25 2002 - 02:58:21 CDT
> 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_at_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
> charliem_at_mwh.com 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: charliem_at_mwh.com
>
> 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: ListGuru_at_fatcity.com (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: alexandre.gorbatchev_at_avermann.de 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: ListGuru_at_fatcity.com (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).
 |
 |