Re: V9.2 SGA

2002-06-25 Thread Alexandre Gorbatchev
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

Re: V9.2 SGA

2002-06-25 Thread Charlie Mengler
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

Re: V9.2 SGA

2002-06-25 Thread Ramon E. Estevez
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:

Re: V9.2 SGA

2002-06-25 Thread Joe Testa
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

RE: V9.2 SGA

2002-06-25 Thread Khedr, Waleed
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

Re: V9.2 SGA

2002-06-25 Thread Ramon E. Estevez
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

RE: V9.2 SGA

2002-06-24 Thread John Kanagaraj
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

Re: V9.2 SGA

2002-06-24 Thread Jared Still
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

RE: V9.2 SGA

2002-06-24 Thread Reardon, Bruce (CALBBAY)
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

Re: V9.2 SGA

2002-06-24 Thread Sakthi , Raj
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.