Re: ORA-04030: out of process memory

Encountering ORA-04030 does not indicate that your PGA is not set high enough; instead it might indicate that it (and perhaps your SGA_MAX_SIZE) is set too high for the server configuration. This particular exception is coming back from the OS, stating that the process supporting your database session attempted to allocated more private process memory for the PGA, but received an "out-of-memory" response from the system call.

If you reduce PGA (or SGA), you'll likely see the incidence of ORA-04030 decrease, but perhaps you might also see the performance of some operations decrease. My thought is that your database instance is either over-configured for the server, or your server is underconfigured for the database instance. In the former case, if the database is over-configured, consider reducing the size of PGA and SGA. If the latter case, if the server is under-configured for the database workload, then you need more memory on that thang.

Another possibility is that you have something else (i.e. JVM or app-server?) sucking up heap memory on this server; is this a dedicated database server, or not? If so, it might make sense to either increase memory on the server or separate the Oracle database instance to a dedicated server. Or, reduce the Oracle instance's memory footprint on this server (i.e. PGA, SGA) until one or the other happens.

Hope this helps,

Tim Gorman

consultant -> Evergreen Database Technologies, Inc.
postal     => PO Box 352151, Westminster CO 80035-2151 USA
web/blog   => http://www.EvDBT.com/
email      => Tim_at_EvDBT.com
mobile     => +1 (303) 885-4526
twitter    => timothyjgorman

president  -> Rocky Mtn Oracle Users Group (www.RMOUG.org)
board      -> Oracle Developers Tools Users Group (www.ODTUG.com)
advisor    -> Northern California Oracle Users Group (www.NoCOUG.org)
secretary  -> Project SafeGuard (www.PSGHelps.org)
member     -> OakTable Network (www.OakTable.net)

Oracle ACE Director (www.oracle.com/technetwork/community/oracle-ace)

Lost Data? => www.ora600.be/ for info about DUDE...

On 2/12/2013 2:17 AM, AMIT VERMA wrote:
> Dear Experts,
> I having a wired problem in DB, of ORA-04030 where as my PGA size is
> already 30 GB however my process only consume 4GB of consumption. Please
> share your thought.
>

--
http://www.freelists.org/webpage/oracle-l