[oracle]11g Memory footprint Adjustment steps

Follow the steps below to adjust the memory

1. Sqlplus/nolog
2. Conn/as SYSDBA

3. Show parameter target

4. Show Parameter SGA
Alter system set SGA_MAX_SIZE=512M Scope=spfile;
Alter system set SGA_TARGET=512M Scope=spfile;

5. Show parameter memory
alter system Set Memory_target = 2048M scope=spfile;
Alter system set Memory_max_target =2048m scope=spfile;

6. Shutdown immediate
7. Startup

If a startup failure occurs, you can start with the default Init.ora file, and the repair process is as follows

1. Use this pfile (Init.ora) file to start Oracle
Startup pfile= ' E:\app\Administrator\product\11.2.0\dbhome_1\dbs\init.ora ';

2. Delete the original spfile and create a new SPFile
Create SPFile from memory;

3. Restart Oracle in the normal way.

sql> Shutdown Abort
Sql> Startup

[oracle]11g Memory footprint Adjustment steps