Setting oralce Automatic Memory Management Execution Steps

Setting up oralce Automatic Memory Management

Enabling oracle automatic memory management requires shutdown, restart

1. Determine the sga pga memory size:

 
SHOW PARAMETER TARGET 

2. Determine the maximum usage size of pga since database startup:

 
select value from v$pgastat where name='maximum PGA allocated'; 

3. Calculate the memory_target size:

 
memory_target = sga_target + max(pga_aggregate_target, maximum PGA 
allocated) 

4. Set memory_target

 
ALTER SYSTEM SET MEMORY_MAX_TARGET = nM SCOPE = SPFILE; 
MEMORY_MAX_TARGET is not a dynamic initialization parameter. 

If you are using text initialization parameter file, you need to edit the following two parameters:

 
memory_max_target = nM 
memory_target = mM 

5.Shut down and restart the database.