ORA-04030 Raised On 'UPDATE diana_version$'

(Doc ID 2393854.1)

Last updated on MAY 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

 ORA-04030 on data pump when compiling plsql procedures

The procedure can be successfully compiled from *SqlPlus using "ALTER ... COMPILE" or using utlrp.sql

On incident trace file can be observed    


    ORA-00603: ORACLE server session terminated by fatal error
    ORA-24557: error 4030 encountered while handling error 4030; exiting server process
    ORA-04030: out of process memory when trying to allocate 8168 bytes (callheap,kcbtmal allocation)
    ORA-04030: out of process memory when trying to allocate 8168 bytes (callheap,kcbtmal allocation)

   

     object      line  object
     handle    number  name
   0xae8dbd40     26101  package body SYS.KUPW$WORKER.RECREATE_DDL
   0xae8dbd40     25226  package body SYS.KUPW$WORKER.PUT_DDL
   0xae8dbd40     24733  package body SYS.KUPW$WORKER.PUT_DDLS
   0xae8dbd40      5084  package body SYS.KUPW$WORKER.LOAD_METADATA
   0xae8dbd40     13108  package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
   0xae8dbd40      2311  package body SYS.KUPW$WORKER.MAIN
   0xb0a4efc0         2  anonymous block
97% ospid 100603      (DW00):

   

=======================================
TOP 10 MEMORY USES FOR THIS PROCESS
---------------------------------------

*** 2018-03-29T19:37:38.747413+03:00
89%   27 GB, 30768640 chunks: "permanent memory          "  
         callheap        ds=0x7efd48090078  dsprt=0x7efd4816d700
 7% 2250 MB, 31029390 chunks: "kprbalo temp memory       "  
         callheap        ds=0x7efd48090078  dsprt=0x7efd4816d700
 4% 1166 MB, 30638204 chunks: "free permanent memory     "  
         callheap        ds=0x7efd48090078  dsprt=0x7efd4816d700
 0%   13 MB, 3239 chunks: "kxsFrame4kPage            "  
         session heap    ds=0x7efd48058fa0  dsprt=0x7efd4816d940

   ...

32 GB used, 32 GB alloc <= CURRENT PROC

 

After setting the below events

ALTER SYSTEM SET EVENTS '4030 trace name heapdump level 536870917;name errorstack level 3';
ALTER SYSTEM SET EVENTS '10235 trace name context forever, level 65536';


In trace file can be observed:

=======================================
TOP 10 MEMORY USES FOR THIS PROCESS
---------------------------------------

*** 2018-04-12T12:33:07.532115+03:00
89%   27 GB, 161230555 chunks: "kprbalo temp me           "     >>>>>>>>>>>>>>>>>>>>>>>>>>>>>> kprbalo temp me 
        callheap        ds=0x7fe6b2d45078  dsprt=0x7fe6b854a700
6% 1771 MB, 46438256 chunks: "permanent memory          "  
        callheap        ds=0x7fe6b2d45078  dsprt=0x7fe6b854a700
2%  709 MB, 46438256 chunks: "CPM trailer               "  
        callheap        ds=0x7fe6b2d45078  dsprt=0x7fe6b854a700



*** 2018-04-12T12:33:29.645633+03:00
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=5y9ddumh4kbk4) -----
update diana_version$ set flags = flags + 1  where  obj# = :1 and bitand(flags, 1) = 0  >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>  update diana_version$
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
 object      line  object


 

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