Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: V9.2 & SGA

RE: V9.2 & SGA

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Tue, 25 Jun 2002 13:10:50 -0800
Message-ID: <F001.004878AA.20020625131050@fatcity.com>


Check on Oracle streams in 9iR2. It is the new way for replication (Almost same technology used in Quest product).

 Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company

-----Original Message-----
Sent: Tuesday, June 25, 2002 4:45 PM
To: Multiple recipients of list ORACLE-L

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: Khedr, Waleed
  INET: Waleed.Khedr_at_FMR.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).
Received on Tue Jun 25 2002 - 16:10:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US