Re: V9.2 SGA
Charlie, You are hardly able to fit two instances of your configuration into 256M along with OS memory requirements. For example, JServer option has additional requirements for java_pool_size. RTFM about OLAP and Data Mining option if they have some additional memory requirements. Partitionning AFAIK doesn't. 32M for 9i SGA - probably impossible or you database will not function properly. The full formula for the total memory requirement of the Oracle9i on unixbackground processes may be found in Oracle9i Administrator's Reference for 9.0.1 Part No. A90347-02 and page 1-14 Oracle9i Memory Requirements. It looks like text + SGA + (n * (data + uninitialized_data + 8192 + 2048) ) see the manual for details. Of course, the SGA is the biggest part when there are few users. -- hth Alexandre - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 25, 2002 12:05 AM 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+SGA2256MB. :-( 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! -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 The Micro$oft Haiku Creed San Diego, CA 92131 Chaos reigns within. Reflect, repent, and reboot. Order shall return. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler 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: Alexandre Gorbatchev 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).
Re: V9.2 SGA
Thanks to all that replied. oracle@actaeon:RPT# sqlplus SQL*Plus: Release 9.2.0.1.0 - Production on Tue Jun 25 06:24:55 2002 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Enter user-name: / as sysdba Connected to: 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 [EMAIL PROTECTED] sho sga Total System Global Area 76514152 bytes Fixed Size 729960 bytes Variable Size 37748736 bytes Database Buffers 33554432 bytes Redo Buffers4481024 bytes When I posted my plea yesterday I was extraordinarily tired frustrated. I'm a command line guy who dislikes GUI wizards, which includes OUI! One of my ongoing complaints WRT the OUI is that it tends to pop informational frames/boxes/windows, but I can NOT cut paste or otherwise capture the contents for later review and such. With V9.2 one such frame included a list of all the initSID.ora changes that were made; such a V7 parameters which went away and V9 parameters which were added. I spent way too much time changing values within the initSID.ora file without seeing any changes in the instance before I realized that OUI had made an spfileSID.ora which was being used to the exclusion of my initSID.ora file. Thanks again to everyone who responded I wish you have better times with V9.2 than I did yesterday. HAND! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler 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).
Re: V9.2 SGA
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+SGA2256MB. :-( 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: Ramon E. Estevez 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).
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 [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+SGA2256MB. :-( 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).
RE: V9.2 SGA
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 [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+SGA2256MB. :-( 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed 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).
Re: V9.2 SGA
Ok. Joe Good luck !!! - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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 [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+SGA2256MB. :-( 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez 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).
RE: V9.2 SGA
Hi Charlie, Variable Size 100663296 bytes Database Buffers 33554432 bytes Redo Buffers 33841152 bytes Which initSGA.ora parameters control the Variable Size piece of the 9i SGA? I'd like to shrink this total to around 32MB. You could change both the 'db_block_buffers' as well as 'shared_pool_size'. I also notice that your 'log_buffer' is also set to 33Mb - you are wasting lotsa memory there.. (see recent thread for redo buffer size). John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 The manuals for Oracle are here: http://tahiti.oracle.com The manual for Life is here: http://www.gospelcom.net ** The opinions and statements above are entirely my own and not those of my employer or clients ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj 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).
Re: V9.2 SGA
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+SGA2256MB. :-( 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: Jared Still 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).
RE: V9.2 SGA
Also, you probably thought of this, but have you looked at v$sga (which seems to be the info you get on startup) and v$sgastat - which has details of each of the sections. On 81714 on NT, v$sga shows: Fixed Size Variable Size Database Buffers Redo Buffers And select pool,sum(bytes) from v$sgastat group by pool; gives 4 rows: blank ( which is sum of fixed_sga, db_block_buffers, log_buffer java pool large pool shared pool The sum of java, large shared is nearly equal to the variable size in v$sga - see below for some links on this difference: From http://www.ixora.com.au/q+a/memory.htm Variable SGA size 6 June 1999 Why is the variable size shown when I type SHOW SGA different than the shared_pool_size I set in the init.ora? Other than the shared pool, the variable area also contains the memory arrays behind V$PROCESS, V$SESSION, V$TRANSACTION, V$LOCK and so on, plus a good number of other things. Some are fixed in size, but many are sensitive to the setting of various init.ora parameters. On some platforms each structure starts on a memory protection boundary, so some extra memory is needed for padding. Nevertheless, this does not affect the size of the shared pool, because Oracle calculates what it needs here on instance startup, and then adds the value of the shared_pool_size parameter before allocating the variable area of the SGA. From askTom http://asktom.oracle.com/pls/ask/f?p=4950:8:965938::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:71012348056,%7Bvariable%7D%20and%20%7Bsize%7D The variable portion of the SGA holds all of the control structures for the SGA itself. The bigger the SGA, the bigger the variable portion. APPROXIMATING SGA SIZE AND SHOWING EXISTING SGA To approximate the size of the SGA (Shared Global Area), use the following formula: ( (db_block_buffers * block size) + shared_pool_size + log_buffers) /.9 ... I guess the above formula would need large pool and Java pool adding in for post version 8 (Java only post 8i) For a detailed discussion see http://asktom.oracle.com/pls/ask/f?p=4950:8:965938::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:365088445659,%7Bvariable%7D%20and%20%7Bsize%7D eg this says every control_file will consume 256 bytes of variable size memory. And http://asktom.oracle.com/pls/ask/f?p=4950:8:965938::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:382418730963,%7Bvariable%7D%20and%20%7Bsize%7D goes on to mention The variable sized component of the SGA, as its name implies, contains data structures that are variably sizes (eg: things like sessions, processes, db_files will affect this marginally -- things like shared_pool_size will large effects on this). The variable size of the SGA is the sum of the sizes of all of these variably sized structures (but not block buffers, they are reported separately). Hope all this helps. Regards, Bruce Reardon -Original Message- Sent: Tuesday, 25 June 2002 11:43 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+SGA2256MB. :-( 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: Reardon, Bruce (CALBBAY) 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).
Re: V9.2 SGA
Charlie, all of the following control the variable size. db_block_buffers ( Of course db_cache_size in 9i) and sharedpool_size and log_buffer_size. The thing to note is you have your log_buffer_size set to way higher than necessary. IMHO For such a small( test ? ) system few KBs would suffice. watch out for the minimum requirement for shared pool size. HTH RS --- Charlie Mengler [EMAIL PROTECTED] 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+SGA2256MB. :-( 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! -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 The Micro$oft Haiku Creed San Diego, CA 92131 Chaos reigns within. Reflect, repent, and reboot. Order shall return. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler 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). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj 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).