ORA-04030 (joxu pga heap,f:MMAN) When Executing Procedures Using Java (Doc ID 1546833.1)

Last updated on APRIL 23, 2013

Applies to:

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

Symptoms

You are executing a Java (JVM) procedure and it fails with the following error:

ORA-04030: out of process memory when trying to allocate 161876048 bytes (joxu pga heap,f:MMAN)

 

The trace file shows that all of the memory is consumed by Java:

PRIVATE MEMORY SUMMARY FOR THIS PROCESS
---------------------------------------
******************************************************
PRIVATE HEAP SUMMARY DUMP
15 GB total:
   15 GB commented, 1547 KB permanent
 8299 KB free (256 KB in empty extents),
     15 GB,   1 heap:    "joxp heap      "            6063 KB free held
------------------------------------------------------
Summary of subheaps at depth 1
15 GB total:
   15 GB commented, 154 KB permanent
 2313 KB free (184 KB in empty extents),
     15 GB,   1 heap:    "joxu pga heap  "          
------------------------------------------------------
Summary of subheaps at depth 2
15 GB total:
   15 GB commented, 3596 KB permanent
  512 KB free (408 KB in empty extents),
     14 GB, 133 chunks:  "f:MMAN                    "

 

The stack trace will be similar to:

kghnospc kghalf ioc_allocate0 iocbf_allocate0 ioc_do_call joet_switched_env_callback ioct_allocate0 eoa_new_mman_segment eoa_new_mswmem_segment eoa_new_mswmem_chunk eoa_new_segment eomsw_giant_block eomsw_allocate_block eoa_new_largeobj eoa_alloc_mswmem_object_no_gc eoa_alloc_mfobj eoa_alloc_mfspace eokt2s_define  eokt2s_execute_rows eoktsn_execute_rows eoktsn8_execute_rows__cst__ eoktsn8_execute_rows oracle_jdbc_driver_T2SPreparedStatement__executeForRows oracle_jdbc_driver_OracleStatement__executeMaybeDescribe oracle_jdbc_driver_OracleStatement__doExecuteWithTimeout oracle_jdbc_driver_OraclePreparedStatement__executeInternal oracle_jdbc_driver_OraclePreparedStatement__executeQuery oracle_jdbc_driver_OraclePreparedStatementWrapper__executeQuery sjoninvk_jit joevm_invoke_jit_5ret joe_run_vm joe_run joe_invoke joet_aux_thread_main seoa_note_stack_outside joet_thread_main sjontlo_initialize joe_enter_vm ioei_call_java ioesub_CALL_JAVA seoa_note_stack_outside ioe_call_java jox_invoke_java_ jox_invoke_java kkxmjexe kgmexcb rpiswu2 kkxmswu kgmexwi kgmexec pefjavacal pefcal pevm_FCAL pfrinstr_FCAL pfrrun_no_tool pfrrun plsql_run peicnt kkxexe opiexe kpoal8 opiodr ttcpip opitsk opiino opiodr opidrv sou2o opimai_real main

 

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