Skip to content

Database Administration (MOSC)

MOSC Banner

Setting up AMM (automatic memory management) in 12c

edited Jul 5, 2017 10:56AM in Database Administration (MOSC) 9 commentsAnswered

Let me know if following 2 options are correct way of setting up AMM in 12c.

(1) During Oracle database installation , the DBCA gives you an option to turn on AMM (automatic memory management) you can check that option and by default allocate 40% of physical memory available.

   Ex:-  Total 50GB ram on the physical server and by using the above option it allocates 20GB to Oracle database.

   Going forward with this new database we can say that AMM is enabled.

(2)  If we have to manually setup AMM on the database.  setup the following spfile parameters and reboot the instance.

memory_max_target=25G

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