假设:oracle安装目录 D:\oracle
数据库的实例名 XXX
内存配置步骤:
1)打开dos,运行
D:\oracle> sqlplus /nolog
SQL> connect / as sysdba
SQL> create pfile from spfile;
SQL> shutdown immediate
SQL> exit
2)打开文件D:\oracle\ora92\database\INITXXX.ORA
修改以下值并保存:
*.db_cache_size=819m
*.shared_pool_size=256m
*.pga_aggregate_target=256m
*.large_pool_size=64m
*.java_pool_size=64m
3)删除文件D:\oracle\ora92\database\SPFILEXXX.ORA
4)打开dos,运行
D:\oracle> sqlplus /nolog
SQL> connect / as sysdba
SQL> startup
SQL> create spfile from pfile;
SQL> exit