不折腾好环境不学习系列 Windows（3）——Oracle 内

create pfile='D:/WINDOWS.X64_180000_db_home/dbs/urgent.ora' from spfile;

在'D:/WINDOWS.X64_180000_db_home/dbs/urgent.ora'中修改

*.memory_max_target=500m

*.memory_target=500m

*.pga_aggregate_target=156m

*.sga_max_size=300m

 *.sga_target=300m 

orcl.__pga_aggregate_target=156m 

orcl.__sga_target=300m

注意：memory_target > pga_aggregate_target + sga_target !!!

startup pfile='D:/WINDOWS.X64_180000_db_home/dbs/urgent.ora';

create spfile from pfile='D:/WINDOWS.X64_180000_db_home/dbs/urgent.ora';

startup

也可以在启动了的情况下：

登录SYS用户修改Oracle的SGA等相关参数，降低内存占用，按Window键和R键，输入SQLPLUS，输入 sys as sysdba，回车，接着回车。

SQL>alter system set sga_max_size = 300M scope=spfile;

SQL>alter system set sga_target = 300M scope=spfile;

SQL>alter system set pga_aggregate_target = 156M scope=spfile;

SQL>alter system memory_target = 500M scope=spfile;

SQL>alter system set memory_max_target = 300M scope=spfile;

SQL>shutdown immediate

SQL>startup