| Cant increase the SGA [message #289564] |
Mon, 24 December 2007 01:18  |
saagar
Messages: 79
Registered: December 2007
|
Member |
|
|
hi all
i have encountered some wired problem
i have windows 2003 server 32 bit on which i have installed oracle 9i on it its physical ram is 4GB it is showing that but when ever i want to increase its SGA more than 700MB it gives me error after when i want to open database it wouldnt let me in also
it gives ORA-12700 Shared Memory Realm Already exist...
please help me to solve this error... and another error while compling huge PL/SQL .......its gives error ORA-065550 and PLS-00123 program too large
please help me to resolve this error....
regards
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Cant increase the SGA [message #289587 is a reply to message #289564] |
Mon, 24 December 2007 03:14  |
halfydba
Messages: 20
Registered: November 2007
Location: Australia
|
Junior Member |
|
|
If your PL/SQL is that large, I think you need to consider making it more modular.
If you can't increase your SGA, you have probably run out of memory. Check what else is consuming memory on the box.
|
|
|
|
| Re: Cant increase the SGA [message #289684 is a reply to message #289587] |
Tue, 25 December 2007 06:10 |
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
|
Senior Member |
|
|
You can not increase SGA_MAX_SIZE to bigger than 1512MB if your machine is server. Due to Windows 32 bit does not manage big memory and big file. Consider about the VLM and change it into 64 bit. The VLM - very large memory in Metalink, basic search.
|
|
|
|
| Re: Cant increase the SGA [message #290647 is a reply to message #289684] |
Mon, 31 December 2007 00:36 |
mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai
|
Member |
|
|
It is not fair to say that windows 2003 server will give you memory insufficient errors provided your OS is properly configured. Installing / running Oracle on a machine which is not properly configured may result in unexpected behavior from Oracle Server. windows 2003 server is designed in such a way that what ever amount of memory a process requests will be provided if not from physical then from virtual {swap). If more swap is being used than also not a healthy environment for oracle. Please do following checks hope your problem should vanish:-
(a) Put service pack 2 if you are not using windows 2003 R2 server. R2 or SP2 automatically enable /PAE flag.
(b) check you have /PAE flag enabled [ mycompter -->Rtclick-->Properties -->General tab should see "Physical Address Extension"].
(c)Check if any other non oracle windows process is not consuming significant amount of memory if so uninstall such programs.
(d) In your production environment please do not install any thing else on server other than OS & oracle.[ Oracle loves privacy if you expect performance from it].
(e) Remember 95% of Oracle misbehaviors are caused by improperly / poorly configured/tuned OS.
(f) Remember 90% of DBA's are not comfortable with OS they are using with Oracle.
(g) Check your swap file size make it 4 to 5 times physical memory.
If still not clear than you are welcome to write back
Regards
Manjit Kumar
[Updated on: Mon, 31 December 2007 03:05] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
