Home » RDBMS Server » Server Administration » ORA-4030 out of process memory when trying to allocate 246296 bytes (QERHJ hash-joi,kllcqas:kllslt (Oracle 10.2.0.2.0 on solaris 5.9)
icon5.gif  ORA-4030 out of process memory when trying to allocate 246296 bytes (QERHJ hash-joi,kllcqas:kllslt [message #304685] Thu, 06 March 2008 03:14 Go to next message
harry07
Messages: 61
Registered: June 2007
Location: now york
Member
Hi Forum

I am getting following error on oracle 10.2.0.2 on solaris 5.9, while executing sql queries.

ORA-04030: out of process memory when trying to allocate 246296 bytes (QERHJ hash-joi,kllcqas:kllsltba)

I have bounced the system and also decreased the parallel_max_server paramter from 320 to 16. But no success.

Queries are not executing and constantly erroring out with this error.

Thanks a lot in advance.
Re: ORA-4030 out of process memory when trying to allocate 246296 bytes (QERHJ hash-joi,kllcqas:klls [message #304691 is a reply to message #304685] Thu, 06 March 2008 03:35 Go to previous messageGo to next message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-04030: out of process memory when trying to allocate %s bytes (%s,%s)
 *Cause:  Operating system process private memory has been exhausted


http://www.orafaq.com/search/ORA-04030

Regards
Michel
Re: ORA-4030 out of process memory when trying to allocate 246296 bytes (QERHJ hash-joi,kllcqas:klls [message #304835 is a reply to message #304691] Thu, 06 March 2008 19:17 Go to previous messageGo to next message
rhziaDBA
Messages: 17
Registered: February 2008
Location: Madrid
Junior Member
YOU MUST INCREASE YOUR SHARED POOL
Re: ORA-4030 out of process memory when trying to allocate 246296 bytes (QERHJ hash-joi,kllcqas:klls [message #304836 is a reply to message #304685] Thu, 06 March 2008 19:37 Go to previous messageGo to next message
BlackSwan
Messages: 22718
Registered: January 2009
Senior Member
>YOU MUST INCREASE YOUR SHARED POOL
With free advice, you get what you paid for it.
Re: ORA-4030 out of process memory when trying to allocate 246296 bytes (QERHJ hash-joi,kllcqas:klls [message #304861 is a reply to message #304835] Fri, 07 March 2008 00:05 Go to previous messageGo to next message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And don't post in CAPITALS.

Regards
Michel
Re: ORA-4030 out of process memory when trying to allocate 246296 bytes (QERHJ hash-joi,kllcqas:klls [message #304909 is a reply to message #304861] Fri, 07 March 2008 02:35 Go to previous messageGo to next message
harry07
Messages: 61
Registered: June 2007
Location: now york
Member
Thanks Guys.........
Re: ORA-4030 out of process memory when trying to allocate 246296 bytes (QERHJ hash-joi,kllcqas:klls [message #574144 is a reply to message #304691] Mon, 07 January 2013 07:08 Go to previous messageGo to next message
sudheergodgeri
Messages: 7
Registered: December 2010
Location: Mumbai, India
Junior Member

Increasing SGA/shared pool is not always the solution for this type of error:
Check the code that triggers this : is it trying to pull in all records of a large table in the
recordset property ( applicable to dotnot/ java /vb platforms) ? Can u instead code to pick about
1000/2000 records/rows at a time, then go for the next lot?

out of process memory can also be due to runaway code that attempts to load all rows of a table
in memory array - then triggers such errors.
Re: ORA-4030 out of process memory when trying to allocate 246296 bytes (QERHJ hash-joi,kllcqas:klls [message #574146 is a reply to message #574144] Mon, 07 January 2013 07:16 Go to previous message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Increasing SGA/shared pool is not always the solution for this type of error:


It is NEVER the solution as this error has nothing to do with shared pool or SGA.

It is nice you want to answer but maybe you could take questions that are not 5 years old.

Regards
Michel
Previous Topic: high REDO generation
Next Topic: "_corrupted_rollback_segments" and "_offline_rollback_segments"
Goto Forum:
  


Current Time: Sat Aug 30 06:03:27 CDT 2014

Total time taken to generate the page: 0.91649 seconds