ORA-04030 Error When High PGA Allocation Under "koh-kghu call=>"pl/sql vc2" Reaches 15GB. (Doc ID 1506315.1)

Last updated on MAY 23, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.5 to 11.2.0.4 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

Following ORA-04030 error is encountered every time when the PGA allocation reaches 15GB:

ORA-04030: out of process memory when trying to allocate 16328 bytes (koh-kghu call ,pl/sql vc2)

The incident trace shows 15G used by pl/sql:

=======================================
TOP 10 MEMORY USES FOR THIS PROCESS
---------------------------------------
100%   15 GB, 1008569 chunks: "pl/sql vc2                "  PL/SQL
        koh-kghu call   ds=fffffc7ffc6f51f8  dsprt=c715710
0%   15 MB, 15763 chunks: "free memory               "  
        pga heap        ds=c715710  dsprt=0

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms