ORA-ERROR 4030

[Deepak Seth_1]

We use Baan 5 on our K-580 running hpux 11.0 . The baan folks are running into some kind of problem running a process which updates the data dictonary . somehow the process dies and give an ORA-4030 error in baan logs. I have already done the following

- increased the maxdsize to 1 gig , maxssize to 385 meg and maxtsize to 1 gig also.
- there is enough swapspace on the system .

Also while debugging the things while the process was running i saw in glance that the process reached 916 meg and then dies . The memory utilization on the system during its running came to as low as 3-5 megs and i saw lots of page out as well.
But there are no error messages in syslog .

Any idea what should i look for or debug the problem ?

[Steven E. Protter]

From Oracle's metalink

PURPOSE ======= Provide assistance in resolving ORA-4030 errors on UNIX systems. SCOPE & APPLICATION =================== This document is useful for DBA's and System Administrators tasked with resolving an ORA-4030 error. BACKGROUND ========== The ORA-4030 error is caused when an Oracle process(while doing work on behalf of a client program) requests additional memory from the operating system, but the operating system cannot accommodate the request. This can occur because the operating system does not have enough physical memory or swap available for the process, the OS is configured to limit the amount of memory available for UNIX processes or an actual Oracle BUG has been encountered. HOW TO RESOLVE THE ORA-4030 =========================== 1. Reduce the PGA (Program Global Area) for the client process encountering the error. This is valid if the database is not configured with MTS (Multi Threaded Server) or Shared Servers. For Oracle 8i and below the major portion of ORA-4030 instances can be solved by reducing the SORT_AREA_SIZE for the sessions. This will lessen the demand that the process places on physical memory. SORT_AREA_SIZE can be modified by the 'alter session' command but persistent changes must be recorded in the init.ora. See the Oracle Reference guide available on your Online Generic Documentation CD-ROM for more information on the 'sort_area_size' parameter. For Oracle 9i and up, the PGA can be sized using the PGA_AGGREGATE_TARGET parameter set in the init.ora or spfile.ora (See [NOTE:153367.1] and [NOTE:146577.1]). 2. Increase the amount of memory a UNIX process can request and use from the operating system. This usually refers to stack and/or data size UNIX process resource limits. This process varies slightly depending on the UNIX platform and the type of UNIX shell you are using. Generally speaking either the 'limit' or 'ulimit' command will allow your System Administrator to increase memory and data size limits. Oracle Support cannot recommend a specific value for these limits. However, doubling existing values or setting them to 'unlimited' is usually sufficient. For more information please refer to: [NOTE:188149.1] How to Display and Change UNIX Process Resource Limits 3. Increase the amount of swap available on your system. You should have 2-3 times the amount of physical memory available as swap space. How to Display the Amount of Physical Memory and Swap Space on UNIX Systems 4. Finally, if you still experience the problem after addressing the above issues, it's recommended that you move to the latest patchset release to eliminate any possible Oracle product defects: [NOTE:169547.1] Understanding and Obtaining Oracle RDBMS Patchsets REFERENCES ========== [NOTE:19836.1] OERR: ORA 4030 "out of process memory when [NOTE:1023744.6] ORA-04030 -07324: AFTER INCREASING THE SGA OR EXECUTING A LARGE QUERY [NOTE:61896.1] SOLARIS: SGA size, sgabeg attach address and Sun architectures [NOTE:153655.1] SOLARIS Determing Oracle Memory Usage on Solaris AIX Determining Oracle memory usage on AIX [NOTE:174555.1] Determining the Size of an Oracle Process

You might want to run the attached rda utility and see what data it collects.

P

[Deepak Seth_1]

most of things in the meta link documented is already experimented like decreasing the sort area size , increaseing SGA , changing maxdsize except swap space - which i think is ok . Is 2 gig on 3.75 gig RAM ok ? I don't see it reaching around 80 % during the time when the process was running but never get any thing in syslog.

[Steven E. Protter]

You might find something interesting in the rda utility. If you have an oracle support contract, they're going to want to see the output anyway. The output is readable by regular folks like sysadmins.

P