On 32 bit windows 2003, oracle extend sga to max 1.7GB
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@]
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博客 ” ，链接：https://blog.itpub.net/9907339/viewspace-1052291/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
