Re: ORA-04030: Out of process memory ERROR

What's the other error? I've seen the 4030 followed by a ora-07324. In fact I'm using 7.3.4 on aix 4.3.2 and I got one last month. We bumped up the ulimit and I wrote a script to monitor the application process's memory usage (ps vg). Last week it struck again. What I found was that the shadow process for the application leveled out at 50 meg or so for 2 weeks. All of a sudden, it started growing by leaps and bounds until we got the error at 200 meg. I looked into it at Oracle's metalink has some info on it. My problem seems to be some type of memory leak. They're looking into it now. If the process has been running for extended periods of time, try restarting it. I don't know if this is the same problem you're having, but it may be something you can look into.

Steve

"M. Rothwell" wrote:

> I am getting the following error when doing an insert into... select....
>
> ORA-04030: out of process memory when trying to allocat 10232 bytes
> (pga hep, ksm stack)
>
> I am selecting from 3 tables, One main table that has about 4.3M records
> and two small lookup tables. The query is grouping by several columns.
>
> This query is running for about 1/2 hour before it blows up. I have
> verified that is is using indexes for the joins.
>
> We have called Oracle, they have no answers except to say the it should
> be fixed in the next version.
>
> Running Oracle 8.0.5.1.0.0
> AIX 4.3 on a 4 CPU RS6000 with 2M ram.
>
> I'm not running out of temp space or rollback space, and the OS is not
> paging.
>
> Any ideas would be greatly appreciated.
>
> Thanks.
>
> Michael.
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Mon Jul 19 1999 - 22:28:21 CDT