V9.2 & SGA

From: Charlie Mengler <charliem_at_mwh.com>
Date: Mon, 24 Jun 2002 14:05:30 -0800
Message-ID: <F001.00485DA0.20020624140530@fatcity.com>

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).

Received on Mon Jun 24 2002 - 17:05:30 CDT