Memory_target and Memory_max_target

While configuring oracle database for memory configuration options, we can use either of the following options:

• Use Automatic Shared Memory Management
• Use Manual Shared Memory Management
• User Automatic Memory Management

And Automatic Memory Management (AMM) has two initialization parameters :

• MEMORY_TARGET:  It is the amount of shared memory available for oracle instance to use. And the memory is dynamically allocated among SGA and PGA initialization parameters .

  MEMORY_TARGET=SGA + PGA

• MEMORY_MAX_TARGET: This parameter defines the maximum size that the MEMORY_TARGET can be increased to while the instance is up and running.

N.B:   MEMORY_TARGET can not be greater than MEMORY_MAX_TARGET