Home » RDBMS Server » Server Administration » ora-04030 (oracle db , 10.2.0 , windows 2003 server)
ora-04030 [message #349893] Tue, 23 September 2008 07:16 Go to next message
merhanatef
Messages: 28
Registered: September 2008
Junior Member

im using AWE (both /3GB & /PAE flags in the boot.ini file), i'm allocating 7gb of ram to the sga , 500 mb of ram to the pga & im getiting the following ora error:

ORA-04030 OUT OF PROCESS MEMORY WHEN TRYING TO ALLOCATE STRING BYTES(STRING,STRING)
CAUSE:OPERATING SYSTEM PROCESS PRIVATE MEMORY HAS BEEN EXHAUSTED.

so what exactly is the problem & how can i solve it?
Re: ora-04030 [message #349896 is a reply to message #349893] Tue, 23 September 2008 07:26 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is the problem? Oracle can't allocate memory
How can you solve it? You can't, you have to switch to 64bit OS.

Regards
Michel
Re: ora-04030 [message #349906 is a reply to message #349893] Tue, 23 September 2008 07:59 Go to previous messageGo to next message
merhanatef
Messages: 28
Registered: September 2008
Junior Member
read the following note in metalink:
NOTE:373602.1 How To Avoid ORA-04030/ORA-12500 In 32 Bit Windows Environment
Re: ora-04030 [message #350578 is a reply to message #349906] Thu, 25 September 2008 08:26 Go to previous messageGo to next message
merhanatef
Messages: 28
Registered: September 2008
Junior Member
i'm wondering if the number of remote connections to the db server has an impact on consuming the memory resources of the os allocated for the oracle server ,
coz the only differance made on the server was creating multible limited users on the db server for performing some administrative tasks(all db admins) ...
how about them all connecting with the same os user?
what do u think? thanx .....
Re: ora-04030 [message #350581 is a reply to message #350578] Thu, 25 September 2008 08:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
i'm wondering if the number of remote connections to the db server has an impact on consuming the memory resources of the os allocated for the oracle server ,

Yes, it has, each session needs a minimum of memory on the server above all if you use dedicated server (as explained in the Metalink note).

Regards
Michel
Re: ora-04030 [message #350684 is a reply to message #349893] Thu, 25 September 2008 22:16 Go to previous messageGo to next message
ora110
Messages: 42
Registered: September 2007
Location: China
Member

linux based system is a good choice.
Re: ora-04030 [message #350724 is a reply to message #350684] Fri, 26 September 2008 00:59 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I'm sure this will help OP to solve his problem on Windows.

Regards
Michel
Previous Topic: Installation on Windows vista.
Next Topic: Regardin LOG_BUFFER
Goto Forum:
  


Current Time: Sun Dec 04 04:20:39 CST 2016

Total time taken to generate the page: 0.13502 seconds