Re: Need advice on ORA-04030 and pga_aggregate_target parameter

On Mon, 14 May 2007 13:23:47 -0700, harvinder76 wrote:

> Users are getting following errors on 1 of the database machine:
> "Oracle.DataAccess.Client.OracleException ORA-04030: out of process
> memory when trying to allocate 16396 bytes (koh-kghu call ,pmuccst:
> adt/record)"

The error here is: "out of process memory", which means that you have problems with the address space of the process. On Linux, you can increase the limits in /etc/security/limits.conf, if there are any. You can play with data segment size and address space size, both limits are in KB. You should first check whether there are any limits for user oracle bu logging into oracle and executing ulimit -a. Also, you should set overcommit_memory to 1, which will allow processes to allocate memory without having an adequate space on the swap partition first. The error "ORA-04030: out of process memory when trying to allocate 16396 bytes (koh-kghu call ,pmuccst: adt/record)" simply means that a malloc call has failed. Also, check /var/log/messages on the server side, as well as $ORACLE_BASE/admin/$DB_NAME/bdump/alert_$ORACLE_SID.log

-- 
http://www.mladen-gogala.com