Home » RDBMS Server » Server Administration » ORA-04030: out of process memory
ORA-04030: out of process memory [message #61973] Tue, 15 June 2004 02:51 Go to next message
Arindam Saha
Messages: 15
Registered: May 2004
Junior Member
My db version is 9.0.1, which is  running on Windows NT 4.0 server in shared server mode. Most of the time, the db buffer cache hit ratio,  the library cache and the dictionary cache hit ratio are upper 90s. There are concurrent 80 concurrent sessions at the peak business hours and around 40 at off peak hours. The database is being encountered ORA-00600: internal error code  quite frequently with the subsequent arguments [[17285]] followed by ORA-04030: out of process memory when trying to allocate 1257324 bytes (PLS non-lib hp,PL/SQL STACK). Can anyone tell me the posible reasons of such error and the solutions, if any.

Report message to a moderator

Re: ORA-04030: out of process memory [message #119919 is a reply to message #61973] Mon, 16 May 2005 12:56 Go to previous messageGo to next message
geluionescu
Messages: 1
Registered: May 2005
Location: Romania Galati
Junior Member
Hello !
did anyone answered to your question about ora-04030
'couse I'm facein' it Sad
Tx
Gelu

Report message to a moderator

Re: ORA-04030: out of process memory [message #119935 is a reply to message #61973] Mon, 16 May 2005 15:36 Go to previous messageGo to next message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
ora-600 are internal oracle error codes, many of which will go away if you patch to a more stable version, such as 9.2.0.6.

Also, is your server itself running out of RAM and virtual memory?

And are you really running on NT 4.0 in a production system that active? I didn't know people still ran NT.

Report message to a moderator

Re: ORA-04030: out of process memory [message #119941 is a reply to message #119935] Mon, 16 May 2005 17:03 Go to previous message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi

Please check out below written things
---------------------------------------------------------
ORA-04030 out of process memory when trying to allocate string bytes (string,string)

Cause: Operating system process private memory has been exhausted.

Action: See the database administrator or operating system administrator to increase process memory quota. There may be a bug in the application that causes excessive allocations of process memory space.
----------------------------------------------------------
sunil

Report message to a moderator

Previous Topic: Oracle Network Libraries
Next Topic: WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 27 02:21:57 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.