OraFAQ Forum: Server Administration » ORA-4030 out of process memory when trying to allocate 246296 bytes (QERHJ hash-joi,kllcqas:kllslt

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)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

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.

Report message to a moderator

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

Michel Cadot
Messages: 68641
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

Report message to a moderator

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

rhziaDBA
Messages: 17
Registered: February 2008
Location: Madrid

Junior Member

YOU MUST INCREASE YOUR SHARED POOL

Report message to a moderator

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>YOU MUST INCREASE YOUR SHARED POOL
With free advice, you get what you paid for it.

Report message to a moderator

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

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

And don't post in CAPITALS.

Regards
Michel

Report message to a moderator

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

harry07
Messages: 61
Registered: June 2007
Location: now york

Member

Thanks Guys.........

Report message to a moderator

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

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.

Report message to a moderator

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

Michel Cadot
Messages: 68641
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

Report message to a moderator

Previous Topic:	high REDO generation
Next Topic:	"_corrupted_rollback_segments" and "_offline_rollback_segments"

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 18:56:26 CDT 2024