ORA-4031 - Trace File Confirms Large Number Of "miscellaneous" Chunks (Doc ID 1314268.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 9.0.1.0 to 9.2.0.8 - Release: 9.0.1 to 9.2
Information in this document applies to any platform.

Symptoms

ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","DBMS_METADATA_INTSYS","PL/SQL MPCODE","BAMIMA: Bam Buffer")
ORA-06508: PL/SQL: could not find program unit being called
===============================
Memory Utilization of Subpool 1
===============================
Allocation Name           Size
_________________________ __________
"free memory "              59610696
"miscellaneous "           291543296 <== largest chunk
"KGLS heap "                 1589648
"ges enqueues "             74131360
"sim memory hea "            1646944
"trigger source "               2896
...

DIAGNOSTIC ANALYSIS
Example:
--------
...
Breakdown of CPRM Chunks (Commented Perm Chunks)

               Type            Count              Sum          Average
               ~~~~            ~~~~~              ~~~          ~~~~~~~
                ...
      state objects            21290         89198992          4189.71
                ...
Example:
--------

SO: 7000002b620a6a0, type: 24, owner: 7000002cb354558, flag: INIT/-/-/0x80
(buffer) PR: 0x7000002b315f8c0 FLG: 0x0
lock rls: 0x0, class bit: 0x0
kcbbfbp: [BH: 0x0, LINK: 0x7000002b620a6e0]
where: ktspbwh1: ktspfsrch, why: 0
----------------------------------------
SO: 7000002b61f9c30, type: 24, owner: 7000002cb354558, flag: INIT/-/-/0x80
(buffer) PR: 0x7000002b315f8c0 FLG: 0x0
lock rls: 0x0, class bit: 0x0
kcbbfbp: [BH: 0x0, LINK: 0x7000002b61f9c70]
where: ktspbwh1: ktspfsrch, why: 0
----------------------------------------
SO: 7000002b61ea4c8, type: 24, owner: 7000002cb354558, flag: INIT/-/-/0x80
(buffer) PR: 0x7000002b315f8c0 FLG: 0x0
lock rls: 0x0, class bit: 0x0
kcbbfbp: [BH: 0x0, LINK: 0x7000002b61ea508]
where: ktspbwh1: ktspfsrch, why: 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