SGA_MAX_SIZE, SGA_TARGET, MEMORY_TARGET AND MEMORY_MAX_TARGET PLAYS A MAJOR ROLE IN ENHNACING THE PEFORMANCE OF THE DATABASE :

>> INCREASE THE SGA_MAX_SIZE PARAMETER IN ACCORDANCE WITH THE RAM OF THE SERVER MACHINE :

ALTER SYSTEM SET SGA_MAX_SIZE = 20G SCOPE=BOTH;

OR

ALTER SYSTEM SET SGA_MAX_SIZE = 20G SCOPE=SPFILE;

- NOTE : THE RAM OF THE MACHINE SHOULD BE FAR GREATER THAN 20G IN ABOVE CASE (e.g. 80GB ).

 >> INCREASE THE MEMORY_TARGET PARAMETER IN ACCORDANCE WITH THE RAM OF THE SERVER MACHINE :



ALTER SYSTEM SET MEMORY_TARGET = 20G SCOPE=BOTH;

OR

ALTER SYSTEM SET MEMORY_TARGET = 20G SCOPE=SPFILE;


>>  INCREASE THE MEMORY_MAX_TARGET PARAMETER IN ACCORDANCE WITH THE RAM OF THE SERVER MACHINE :


ALTER SYSTEM SET MEMORY_MAX_TARGET = 20G SCOPE=BOTH;

OR

ALTER SYSTEM SET MEMORY_MAX_TARGET  = 20G SCOPE=SPFILE;


NOTE : KEEP THESE 3 PARAMETERS VALUE SAME(SGA_MAX_SIZE = 20G,MEMORY_TARGET = 20G, MEMORY_MAX_TARGET = 20G) FOR ENHANCED PERFORMANCE OF THE DATABASE AND FOR AMM AND ASMM TO BE ENABLED.