Joe, what happened with your weekly tip about 9i ? Ramon
----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, June 24, 2002 9:58 PM > For those who dont know(and might not care), > > OLD: db_block_buffers > NEW: db_cache_size > OLD: buffer_pool_keep > NEW: db_keep_cache_size > OLD: buffer_pool_recycle > NEW: db_recycle_cache_size > > NEW: db_2K_cache_size > NEW: db_4k_cache_size > NEW: db_8k_cache_size > NEW: db_16K_cache_size > NEW: db_32K_cache_size > NEW: sga_max_size > > Joe > > > > Jared Still wrote: > > >Try shared_pool_size, large_pool_size, java_pool_size and > >shared_pool_reserved size. > > > >This is from 8i, there may be additional ones on 9i, or 1 or 2 > >of those I mentioned may be deprecated. > > > >Jared > > > >On Monday 24 June 2002 15:05, Charlie Mengler 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! > >> > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Joe Testa > 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: Ramon E. Estevez 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).