Hello all...

Sun 5.8 / Oracle 9.2 and Oracle8.1.7

This is one question that always have at the back of my mind ...

How do we estimate the size of the SGA ?.....Like say when i created a database using DBCA, it already assigns some default SGA values.

Is there a "Rule of Thumb" for assigning SGA values for each instance..?...Most of my databases have atmost 25-50 connections at a given time with about 1GB data. ...

How do we calculate the SGA values for these kinds of Databases ?...

currently i have values ranging from :
320,308,312 to 48,075,571

So can anyone pleas expalin how to estimate the SGA values ?


Thanks
Ron