New features in 10g to help manage the SGA. When SGA_TARGET large then 0, it means the ASMM is enable. Disable the AMM by set MEMORY_TARGET to 0. after the setting, you can see the SGA_TARGET change from 0 to 608MB.
set the memory_target=0 is to disable the AMM. This will change the AMM to ASMM.
If you don’t have the AMM enable, then just set the SGA_TARGET to enable the ASMM. SGA_TARGET is the dynamic value as long as you set it small than SGA_MAX_SIZE.
- SGA_TARGET must small than SGA_MAX_SIZE.
- SGA_MAX_SIZE is static value. To change the SGA_MAX_SIZE require bounce the oracle instance.
Show the free memory that we can add to the SGA. The difference between SGA_MAX_SIZE and SGA_TARGET. ( SGA_MAX_SIZE- SGA_TARGET)
Show the size of the SGA dynamic components.
We can use it to determine whether the SGA_TARGET is bigger enough or we can reduce the memory.