On 32 bit windows 2003, oracle extend sga to max 1.7GB

maojinyu發表於2011-07-12
WindowsOracle
changed:

2.1 boot.ini: add /3GB
[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(1)WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)WINDOWS="Windows Server 2003, Enterprise" /fastdect noexecute=alwaysoff /3GB

2.2 restart the computer
2.3
SQL>alter system set sga_target=2100M scope=spfile;
SQL>shutdown immediate;
SQL>startup;
SQL>show parameter sga

SQL>alter system set pga_aggregate_target=400M;
SQL>show parameter pga;[@more@]

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/9907339/viewspace-1052291/，如需轉載，請註明出處，否則將追究法律責任。

相關文章