My Oracle Support Banner

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

Last updated on FEBRUARY 19, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 9.0.1.0 to 9.2.0.8 [Release 9.0.1 to 9.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
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
...






Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.