What is the difference between memory_target and memory_max_target initialization parameters in oracle database instance?
meda Changed status to publish 03/12/2024
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
meda Edited answer 06/05/2022