Oracle Memory Management

Automated management of memory in Oracle 11g

The value of Memory_target is greater than/DEV/SHM and will error Ora-00845:memory_target not supported on the This system fault,

In Redhat series systems, the default value of/DEV/SHM is half the total system memory

Alter system set MEMORY_MAX_TARGET=1024M Scope=spfile;

Alter system set MEMORY_TARGET=1024M Scop=spfile;

Alter system set sga_target=0 Scope=spfile;

Alter system set SGA_MAX_SIZE=0 Scope=spfile;

Alter system set pga_aggregate_target=0 Scope=spfie;

--View SGA

Show parameter SGA;

--View actual PGA

SELECT * FROM V$pgastat

Oracle Memory Management