Re: V9.2 & SGA

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