Database Administration (MOSC)

MOSC Banner

How to determine sga for new database?

edited Oct 13, 2010 1:40AM in Database Administration (MOSC) 6 commentsAnswered
 I have a unix solaris 10 box with shmmax set to 4096000000.

When I issued top, I got 8192M phys mem and 3359M free mem.

There are already four databases on this box with sga setting as follows:

database 1: total sga 541065216 bytes

database 2: total sga 411041792 bytes

database 3: total sga 339738624 bytes

database 4: total sga 415236096 bytes

Right now I need to create a database on this box. How can I determine the max sga the new database can be without having to adjust the shmmax setting? Is it just as simple as subtract the sum of the total sga from each of the four databases from current shmmax? Please advise. Thanks.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center