| ora-04030 [message #349893] |
Tue, 23 September 2008 07:16  |
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 #349906 is a reply to message #349893] |
Tue, 23 September 2008 07:59  |
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 |
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 #350724 is a reply to message #350684] |
Fri, 26 September 2008 00:59 |
 |
Michel Cadot
Messages: 68666
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
