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;
alter system reset memory_target scope=spfile ;
alter system reset memory_max_target scope=spfile ;
shutdown immediate;
startup;
No comments:
Post a Comment