Ok. Joe Good luck !!!
----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, June 25, 2002 3:45 PM > Ramon, it all depends on my workload and its been a bit much lately, i'm > hoping to test logical standby after i get thru studying for 9i upgrade > exam and take the test on mid july. > > joe > > > Ramon E. Estevez wrote: > > >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: 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).