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