Database Has Memory_Max_Target Set Even if Created with AMM Disabled

(Doc ID 1138645.1)

Last updated on OCTOBER 25, 2017

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.1 to 11.2]
Information in this document applies to any platform.
Version: 3-2XSW-27811.1.0.6 to 3-2XSW-72311. [Release: 3-2XST-6211.1 to 3-2XST-7311.2]


When creating a database with DBCA, you explicitly disabled AMM, however when you start the newly created database, you discover there is still a value for the MAX_MEMORY_TARGET.

SQL> show parameter memory_max_target

------------------------------------ ----------- ------------------------------
memory_max_target big integer 30000M


You created the database with AMM disabled in DBCA.


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms