Re: V9.2 & SGA

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