HOW TO ENABLE AUTOMATIC MEMORY MANAGEMENT IN ORACLE - PARAMETERS AND CONDITIONS TO FULFILL FOR AMM AND ASMM :

>> SGA_TARGET SHOULD BE SET TO '0' FOR AUTOMATIC MEMORY MANAGEMENT AND ASMM TO BE ENABLED IN ORACLE DATABASE.

ALTER SYSTEM SET SGA_TARGET=0 SCOPE=BOTH;

OR

ALTER SYSTEM SET SGA_TARGET=0 SCOPE=SPFILE;

>>  THIS CONDITION NEEDS TO BE FULFILLED FOR AUTOMATIC MEMORY MANAGEMENT AND ASMM TO BE ENABLED.