Re: V9.2 & SGA

Ok. Joe

Good luck !!!

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> 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" <ORACLE-L_at_fatcity.com>
> >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_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!
> >>>>
> >>
> >>--
> >>Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >>--
> >>Author: Joe Testa
> >> INET: jtesta_at_dmc-it.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).
> >>
> >
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Joe Testa
> INET: jtesta_at_dmc-it.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ramon E. Estevez
  INET: com.banilejas_at_codetel.net.do

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