ORA-04031

Alert log:
Tue Oct 28 15:02:36 2014
Errors in file /oracle/db/tech_st/11.1.0/admin/ORCL_orcl12db/diag/rdbms/ORCL/ORCL/trace/ORCL_ora_6476.trc (incident=6176661):
ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","INSERT INTO APPS.XXcustom_MODI...","sql area:PLSQL","tmp")
Tue Oct 28 15:02:36 2014
Errors in file /oracle/db/tech_st/11.1.0/admin/ORCL_orcl12db/diag/rdbms/ORCL/ORCL/trace/ORCL_ora_19831.trc (incident=6178405):
ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","INSERT INTO APPS.XXcustom_MODI...","sql area","tmp")
Tue Oct 28 15:02:36 2014
Errors in file /oracle/db/tech_st/11.1.0/admin/ORCL_orcl12db/diag/rdbms/ORCL/ORCL/trace/ORCL_ora_16403.trc (incident=6177549):
ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","INSERT INTO APPS.XXcustom_MODI...","sql area","tmp")
Tue Oct 28 15:02:36 2014
Errors in file /oracle/db/tech_st/11.1.0/admin/ORCL_orcl12db/diag/rdbms/ORCL/ORCL/trace/ORCL_ora_2108.trc (incident=6178773):
ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","INSERT INTO APPS.XXcustom_MODI...","sql area","tmp")
Incident details in: /oracle/db/tech_st/11.1.0/admin/ORCL_orcl12db/diag/rdbms/ORCL/ORCL/incident/incdir_6176661/ORCL_ora_6476_i6176661.trc
Incident details in: /oracle/db/tech_st/11.1.0/admin/ORCL_orcl12db/diag/rdbms/ORCL/ORCL/incident/incdir_6178405/ORCL_ora_19831_i6178405.trc
...


Trace File :
The ORCL_ora_19831.trc trace file shows:

*** 2014-10-28 15:02:35.455
*** SESSION ID:(1843.3362) 2014-10-28 15:02:35.455
*** CLIENT ID:(RSOW BHUSHAN) 2014-10-28 15:02:35.455
*** SERVICE NAME:(SYS$USERS) 2014-10-28 15:02:35.455
*** MODULE NAME:(e:SQLAP:frm:APXINWKB) 2014-10-28 15:02:35.455
*** ACTION NAME:(SQLAP/PAY_USER_INV_BGPPL- OSSB_W) 2014-10-28 15:02:35.455

=================================
Begin 4031 Diagnostic Information
=================================
The following information assists Oracle in diagnosing
causes of ORA-4031 errors. This trace may be disabled
by setting the init.ora _4031_dump_bitvec = 0
=====================================
Allocation Request Summary Informaton
=====================================
Current information setting: 04014fff
SGA Heap Dump Interval=3600 seconds
Dump Interval=300 seconds
Last Dump Time=10/28/2014 15:02:34
Dump Count=1
Allocation request for: tmp
Heap: 0x5cec12f48, size: 32
******************************************************
HEAP DUMP heap name="sga heap" desc=0x60001170
extent sz=0x9800 alt=216 het=32767 rec=9 flg=-126 opc=0
parent=(nil) owner=(nil) nex=(nil) xsz=0x1 heap=(nil)
fl2=0x60, nex=(nil)
ds for latch 1: 0x60047bd8 0x60049430 0x6004ac88 0x6004c4e0
ds for latch 2: 0x60051400 0x60052c58 0x600544b0 0x60055d08
ds for latch 3: 0x6005ac28 0x6005c480 0x6005dcd8 0x6005f530
ds for latch 4: 0x60064450 0x60065ca8 0x60067500 0x60068d58
ds for latch 5: 0x6006dc78 0x6006f4d0 0x60070d28 0x60072580
ds for latch 6: 0x600774a0 0x60078cf8 0x6007a550 0x6007bda8
reserved granule count 0 (granule size 268435456)
******************************************************
HEAP DUMP heap name="sql area" desc=0x5cec12f48
extent sz=0xfe8 alt=32767 het=336 rec=0 flg=2 opc=2
parent=0x60001170 owner=0x5cec12e30 nex=(nil) xsz=0x10000000 heap=(nil)
fl2=0x26, nex=(nil)





Call Stack Trace:
... kghnospc kghalf kksLoadChild kxsGetRuntimeLock kksfbc opiexe opiefn0 kpoal8 opiodr ttcpip opitsk opiino opiodr opidrv sou2o opimai_real ssthrdmain main __libc_start_main _start
----- End of Call Stack Trace -----

   
This is due to unpublished bug:9267837 fixed in 11.2.0.2 and documented in Note:9267837.8.
   
Download and apply one-off patch number 9267837 for 11.1.0.7.0 on Linux x86-64.