My Oracle Support Banner

ORA-04031: unable to allocate 4160 bytes of shared memory ("shared pool","unknown object","init_heap_kfsg","ASM extent pointer array") (Doc ID 2705193.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 to 18.0.0.0 [Release 12.2 to 18]
Information in this document applies to any platform.

Symptoms

The database instance is evicted with the following errors.

alert_<nodename>.log

2020-08-09T21:05:20.414453+04:00
Errors in file $oracle_base/diag/rdbms/node/node2/trace/node2_asmb_12532.trc (incident=61969):
ORA-04031: unable to allocate 4160 bytes of shared memory ("shared pool","unknown object","init_heap_kfsg","ASM extent pointer array")
Incident details in: $oracle_base/diag/rdbms/node2/node2/incident/incdir_61969/node2_asmb_12532_i61969.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
2020-08-09T21:05:24.463796+04:00
NOTE: ASMB0 terminating
2020-08-09T21:05:24.464345+04:00
Errors in file $oracle_base/diag/rdbms/node/node2/trace/node2_asmb_12532.trc:
ORA-04031: unable to allocate 4160 bytes of shared memory ("shared pool","unknown object","init_heap_kfsg","ASM extent pointer array")
2020-08-09T21:05:24.468806+04:00
NOTE: Deferred communication with ASM instance
2020-08-09T21:05:24.468879+04:00
NOTE: Deferred communication with ASM instance
NOTE: deferred map free for map id 64385
2020-08-09T21:05:24.469324+04:00
NOTE: deferred map free for map id 64386
2020-08-09T21:05:24.474953+04:00
Errors in file $oracle_base/diag/rdbms/node/node2/trace/node2_asmb_12532.trc:
ORA-04031: unable to allocate 4160 bytes of shared memory ("shared pool","unknown object","init_heap_kfsg","ASM extent pointer array")
Errors in file $oracle_base/diag/rdbms/node/node2/trace/node2_asmb_12532.trc (incident=61970):
ORA-4031 [] [] [] [] [] [] [] [] [] [] [] []
Incident details in: $oracle_base/diag/rdbms/node2/node2/incident/incdir_61970/node2_asmb_12532_i61970.trc

2020-08-09T21:05:28.526228+04:00
USER (ospid: 12532): terminating the instance due to error 4031
2020-08-09T21:05:28.573031+04:00
opiodr aborting process unknown ospid (12965) as a result of ORA-1092

..

opiodr aborting process unknown ospid (13761) as a result of ORA-1092
2020-08-09T21:05:28.699326+04:00
ORA-1092 : opitsk aborting process
2020-08-09T21:05:28.870741+04:00
opiodr aborting process unknown ospid (10242) as a result of ORA-1092
2020-08-09T21:05:28.915583+04:00
ORA-1092 : opitsk aborting process
2020-08-09T21:05:32.227073+04:00
ORA-1092 : opitsk aborting process
2020-08-09T21:05:34.171304+04:00
Instance terminated by USER, pid = 12532

 node2_asmb_12532_i61969.trc: 

TOC00000]
Jump to table of contents
Dump continued from file: $oracle_base/diagdiag/rdbms/node/node2/trace/node2_asmb_12532.trc
[TOC00001]
ORA-04031: unable to allocate 4160 bytes of shared memory ("shared pool","unknown object","init_heap_kfsg","ASM extent pointer array")

[TOC00001-END]
[TOC00002]
========= Dump for incident 61969 (ORA 4031) ========
[TOC00003]
----- Beginning of Customized Incident Dump(s) -----

*** 2020-08-09T21:05:20.446824+04:00
=================================
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=08/09/2020 21:05:19
Dump Count=1
Allocation request for: ASM extent pointer array
Heap: 426aa00d8, size: 4160
******************************************************
HEAP DUMP heap name="sga heap" desc=3801032b8
extent sz=0xfe0 alt=304 het=32767 rec=9 flg=0x82 opc=0
parent=0 owner=0 nex=0 xsz=0x1 heap=0
fl2=0xe4, nex=0, idx=0
pdb id=0, src pdb id=0
ds for latch 1: 0x380104c10 0x380109518
reserved granule count 0 (granule size 16777216)
******************************************************
HEAP DUMP heap name="init_heap_kfsg" desc=426aa00d8
extent sz=0x1040 alt=32767 het=32767 rec=9 flg=0x3 opc=0
parent=3801032b8 owner=0 nex=0 xsz=0x1000000 heap=0
fl2=0xa4, nex=0, idx=1, dsxvers=1, dsxflg=0x0
dsx first ext=4116ebe70
dsx empty ext bytes=496 subheap rc link=4116ebee0,4116ebee0
pdb id=0, src pdb id=0
Subheap has 554605480 bytes of memory allocated

Holding:
0x380058028 'ASM map headers' (level=2, SGA latch)
Holder Location: kffm2.h LINE:365 ID:kffmAllocate:
Holder Slot: slot=2, efd=4, pdb=0
Holder Context: 0
Latch State:
state=busy [value=0x2e]
holder orapid=46, ospid=12532
wlstate=free [value=0]

..

SO: 0x43d31ae68, type: 4, owner: 0x43e592ea0, flag: INIT/-/-/-/0x00 if: 0x3 c: 0x3
proc=0x43e592ea0, name=session, file=ksu.h LINE:15737 ID:, pg=0, conuid=0
(session) sid: 810 ser: 25177 trans: 0x0, creator: 0x43e592ea0
flags: (0x51) USR/- flags2: (0x409) -/-/INC
flags_idl: (0x1) status: BSY/-/-/- kill: -/-/-/-
DID: 0002-002E-000000100000-0000-00000000, short-term DID:
txn branch: 0x0
edition#: 0 user#/name: 0/SYS
oct: 0, prv: 0, sql: 0x0, psql: 0x0
stats: 0x411e76000, PX stats: 0x1027d63a0
service name: SYS$BACKGROUND
Current Wait Stack:
0: waiting for 'ASM file metadata operation'
msgop=0x2, locn=0x3, =0x0
wait_id=3096851 seq_num=17881 snap_id=3
wait times: snap=0.110296 sec, exc=0.117499 sec, total=2.626776 sec
wait times: max=infinite, heur=2.626776 sec
wait counts: calls=0 os=0
in_wait=1 iflags=0x15a0
There are 3 sessions blocked by this session.

Dumping one waiter:
inst: 2, sid: 966, ser: 9913
wait event: 'latch free'
p1: 'address'=0x380058028
p2: 'number'=0x327
p3: 'why'=0x0
row_wait_obj#: 4294967295, block#: 0, row#: 0, file# 0
min_blocked_time: 0 secs, waiter_cache_ver: 28285
Wait State:
fixed_waits=0 flags=0x23 boundary=0x0/-1

Session Wait History:
elapsed time of 0.000000 sec since current wait
0: waited for 'SGA: allocation forcing component growth'
=0x0, =0x0, =0x0
wait_id=3096853 seq_num=17880 snap_id=26
wait times: snap=0.000000 sec, exc=2.502409 sec, total=2.505193 sec
wait times: max=infinite
wait counts: calls=25 os=25
occurred after 0.000000 sec of elapsed time

Problem Key: ORA 4031
Error: ORA-4031 [4160] [shared pool] [unknown object] [init_heap_kfsg] [ASM extent pointer array] [] [] [] [] [] [] []
[00]: dbgexExplicitEndInc [diag_dde]
[01]: dbgeEndDDEInvocationImpl [diag_dde]
[02]: kghnospc [KGH]<-- Signaling
[03]: kghalo [KGH]
[04]: ksmd_array_ini [KSM]
[05]: ksmdini [KSM]
[06]: kffmAllocate [KFF]
[07]: kfnbMapOp [KFNU]
[08]: kfnbRun [KFNU]
[09]: ksbrdp [background_proc]

 

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
Cause
Solution


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