按如下的步骤调整内存
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 pga
alter system set pga_aggregate_target=512m scope=spfile;
6. show parameter memory
alter system set memory_target = 2048M scope=spfile;
alter system set memory_max_target =2048M scope=spfile;
7. shutdown immediate
8. startup
如果出现启动失败,可以用默认init.ora文件启动,修复过程如下
1.使用此pfile(init.ora)文件启动oracle
startup pfile='E:\app\Administrator\product\11.2.0\dbhome_1\dbs\init.ora';
2.删除原始spfile,并创建新的spfile
create spfile from memory;
3.按照正常方式重启oracle即可。
SQL> shutdown abort
SQL> startup
------------------------------------
其他参考文章:https://blog.csdn.net/wh445306/article/details/102881209
其中提到 sga_target < = sga_max_size <= memory_target <= memory_max_target