Auto Memory Management

To enable automatic memory management

SHOW PARAMETER TARGET
select value from v$pgastat where name='maximum PGA allocated';
memory_target = sga_target + max(pga_aggregate_target, maximum PGA allocated)
ALTER SYSTEM SET MEMORY_MAX_TARGET = nM SCOPE = SPFILE;
The SCOPE = SPFILE clause sets the value only in the server parameter file, and not for the running instance. 
You must include this SCOPE clause because MEMORY_MAX_TARGET is not a dynamic initialization parameter.

Monitoring and Tuning Automatic Memory Management

select * from v$memory_target_advice order by memory_size;
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License