Database Administration (MOSC)

MOSC Banner

Memory used by Oracle database

edited May 19, 2017 5:02AM in Database Administration (MOSC) 2 commentsAnswered

Server:  Dell server, 50GB physical memory

OS:     Windows 2012 R2

DB:      Oracle 11g R2 Standard Edition One/Two


When we install Oracle db, by default it will assign 40% of physical memory to Oracle database.  So assuming it will assign 20GB to Oracle DB. Now if we setup the Oracle DB in AMM (automatic memory management) mode.

memory_max_target=20G

memory_target=20GB

sga_max_size=20G

sga_target=0

pga_aggregate_target=0

Hoping if all my parameters above are correct, we have allocated 20GB memory for Oracle DB on this server.

When we start the server, initially Oracle.exe process (windows task manager) might show up only 3GB used and later during peak hours it can go to a max of 20GB max.  correct ?

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