| Resizing SGA [message #61812] |
Tue, 01 June 2004 03:20  |
Arindam Saha
Messages: 15
Registered: May 2004
|
Junior Member |
|
|
I am managing a database with the following configurations,
O/S: Windows NT 4.0
Physical RAM of the server: 4GB
Memory accessed by Oracle instance: 2 GB
SGA Max Size: 1670675768 bytes or 1593.28 MB
While trying to increase the sga size by 400mb, receiving the following messages;
ORA-27101 shared memory realm does not exist and ORA-27102 out of memory.
How can I increase sga_max_size by 400mb and how can I increase the physical memory for oracle access upto 3GB, which is 2GB at present.
|
|
|
|
| Re: Resizing SGA [message #61818 is a reply to message #61812] |
Wed, 02 June 2004 08:44  |
Mark
Messages: 284
Registered: July 1998
|
Senior Member |
|
|
Arindam,
You have to modify the boot.ini file to include a switch.
[[operating systems]] multi(0)disk(0)rdisk(0)partition(2)WINNT="Windows NT Server Version 4.00" /3GB
multi(0)disk(0)rdisk(0)partition(2)WINNT="Windows NT Server Version 4.00 [[VGA mode]]" /basevideo /sos
This will increase the process address limit to 3gb.
To make oracle.exe aware of this, you need to run imagecfg
c:>imagecfg -l oracle.exe
As always, while making this kind of change, all databases must be shut down.
HTH
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
