-
how to estimate the SGA values ?
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|