Sizing SGA on sun e450

From: Joshua Goodstein <awing_pilot_at_yahoo.com>
Date: 21 Feb 2002 14:01:21 -0800
Message-ID: <924a90f8.0202211401.478092f1@posting.google.com>

I have a e450 2 proc 2GB memory running oracle 8.1.7.x with four instances. I am trying to balance the sga for all of these instances as follows:

instance1 768M SGA
instance2 512M SGA
instance3 256M SGA
Instance4 126M SGA

What values/ equation do I use too decide the following parameters:

db_block_buffers
shared_pool_size
large_pool_size
java_pool_size (not an essential entry curently set to 0) log_buffer

So that they equal the above listed values. I tried using DBA Studio, but that seems to store it's own init<sid> file internally and does not kick back the settings. I understand that different variatons of theses values will yeild the same result. but I'm looking for what some of you guys do to calculate this stuff. None of these instances are what I would consider high traffic (< 1 million rows a day)

thanks in advance
-J Received on Thu Feb 21 2002 - 16:01:21 CST