Re: ORA-04030: out of process memory

>
> Did you monitored the session and overall PGA utilization over many days?
> (e.g. 'session pga memory' in V$SESSTAT and V$SYSSTAT).
>

The system is only 2 weeks old so I have had to make some starting point and then analyse to tune the DB. I have not had control over the development DB so I cant base the production params on previously seen bugs in development...bad project design...

I have checked the two views and have also used v$sqlarea to trap the session which is causing this error to occur...feeding that back to the development team right now!!

>
> What do you mean with "70% of memory buffers" ? How do you check this
> value?
>

run `free` on linux

> If you have enough free memory, ORA-04030 are caused by a limit set on the
> process's data segment. In fact also if at OS level there are many GB of
> free memory, the limit set at process level cannot be crossed. You can check
> your current limits with "ulimit -a".

yeah I checked this out earlier - the processes can use up as much as they like:

[oracle_at_hsdb1 oracle]$ ulimit -mH
max memory size (kbytes, -m) unlimited [oracle_at_hsdb1 oracle]$ ulimit -mS
max memory size (kbytes, -m) unlimited

-A Received on Thu Aug 12 2004 - 23:44:37 CDT