ORA 4030out of process memory when trying to allocate x bytes

[MikeJones]

Hi everyone,

I'm getting the following error on one of our test databases.

declare
*
ERROR at line 1:
ORA-04030: out of process memory when trying to allocate 8208 bytes (call heap,pl/sql vc2)


Disconnected from Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production

The oracle documnetation gives this explanation

$ oerr ora 4030
04030, 00000, "out of process memory when trying to allocate %s bytes (%s,%s)"
// *Cause: Operating system process private memory has been exhausted
// *Action:

Not a lot of help, The thing is that I can/have run this bit of code on its own hundereds of times and it's never caused this error before, however now I have wrapped a loop around it and im executing it around 350 times. The code in question assigns a profile to a user using native dynamic sql and then calls another proc to maintain some info on another table.

Anybody got any ideas as toi why I'm, getting this error all of a sudden, the Box is a DEC Alpha so I'd be surprised if its not got much memory in it???

Thanks in advance,

mike.

 

[MikeLacey]

Mike,

Could you post your code please? or enough to reproduce the problem anyway. Mike
michael.j.lacey@ntlworld.com
Email welcome if you're in a hurry or something -- but post in tek-tips as well please, and I will post my reply here as well.