Thursday, April 28, 2016

oracle how to disable AMM (Automatic Memory Management) ???

Assuming that you have already set values for SGA_MAX_SIZE, DB_CACHE_SIZE, LARGE_POOL_SIZE etc.

alter system reset memory_target scope=spfile ;
alter system reset memory_max_target scope=spfile ;
shutdown immediate;
startup;
 

No comments:

Post a Comment