To set Oralce automatic memory management execution Steps _oracle

Setting up Oralce automatic memory management

Enabling Oracle Automatic memory management requires shutdown, restart

1. Determine the SGA PGA memory size:

Copy Code code as follows:

Show PARAMETER TARGET

2. Determine the maximum use size of PGA since database startup:

Copy Code code as follows:

Select value from V$pgastat where name= ' maximum PGA allocated ';

3. Calculate Memory_target Size:

Copy Code code as follows:

Memory_target = Sga_target + max (Pga_aggregate_target, maximum PGA
Allocated)

4. Set Memory_target

Copy Code code as follows:

ALTER SYSTEM SET memory_max_target = NM SCOPE = SPFILE;
Memory_max_target is not a dynamic initialization parameter.

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

Copy Code code as follows:

Memory_max_target = NM
Memory_target = MM

5.Shut down and restart the database.