Charlie, all of the following control the variable size. db_block_buffers ( Of course db_cache_size in 9i) and sharedpool_size and log_buffer_size. The thing to note is you have your log_buffer_size set to way higher than necessary. IMHO For such a small( test ? ) system few KBs would suffice. watch out for the minimum requirement for shared pool size.
HTH RS --- Charlie Mengler <[EMAIL PROTECTED]> wrote: > 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). __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj 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).