Automatic management of oracle11g MEMORY (SGA+PGA) __oracle

1, view SPFile location

Show parameter SPFile;

2, Backup SPFile

Create pfile= '/oracle/pid/bak/spfileecp.ora ' from SPFile;

3, set up dynamic management parameters automatic management

Note Shared test settings (if memory 15G shared memory cannot be more than 8G)

alter system setpga_aggregate_target=0 Scope=spfile;

alter system setmemory_max_target=18g Scope=spfile;

alter system setmemory_target=18g Scope=spfile;

4. Close the database

Shutdown immediate;

5, open the database

Startup

6. View Database Memory Parameters

Show Parameter mem

Show Parameter SGA

Show parameter PGA

7. Use Backup SPFile

(Setting parameters unreasonable causes the database to be started, you can use Backup SPFile to start the database)

Startuppfile= '/oracle/pid/bak/spfileecp.ora '

Create SPFile from Pfile;