ORA-4031 ("shared pool","unknown object","init_heap_kfsg","ASM extent pointer array") while running rman backup
(Doc ID 2758397.1)
Last updated on MAY 26, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 19.9.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
While running RMAN backup with multiple channels and connecting to one instance , it failed with ORA-04031 .
2021-02-28T13:20:18.610726-08:00
ARC3 (PID:242182): Archived Log entry 1429 added for T-1.S-518 ID 0xed7e3335 LAD:1
2021-02-28T13:25:00.581739-08:00
CIWPEGAP(4):Resize operation completed for file# 57, old size 27743314240K, new size 27743315264K
2021-02-28T13:32:30.457436-08:00 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Errors in file /u01/app/oracle/diag/rdbms/xxxxxxxx/xxxxxxxx1/trace/xxxxxxxx1_asmb_234791.trc (incident=544603) (PDBNAME=CDB$ROOT):
ORA-04031: unable to allocate 3920 bytes of shared memory ("shared pool","unknown object","init_heap_kfsg","ASM extent pointer array") >>>>>>>>>>>>>>>>>>>>>
Incident details in: /u01/app/oracle/diag/rdbms/xxxxxxxx/xxxxxxxx1/incident/incdir_544603/xxxxxxxx1_asmb_234791_i544603.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
[TOC00000]
Jump to table of contents
Dump continued from file:
/u01/app/oracle/diag/rdbms/xxxxxxxx/xxxxxxxx1/trace/xxxxxxxx1_asmb_234791.trc
[TOC00001]
ORA-04031: unable to allocate 3920 bytes of shared memory ("shared
pool","unknown object","init_heap_kfsg","ASM extent pointer array")
[TOC00001-END]
[TOC00002]
========= Dump for incident 544603 (ORA 4031) ========
[TOC00003]
----- Beginning of Customized Incident Dump(s) -----
*** 2021-02-28T13:32:30.460404-08: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=02/28/2021 13:32:29
Dump Count=1
Allocation request for: ASM extent pointer array
Requested from init_heap_kfsg, Heap: 0xb62701c70, size: 3920
******************************************************
idle wait at each sample
[1 sample,
13:31:39]
waited for 'ASM file metadata operation', seq_num: 26396
p1: 'msgop'=0x2
p2: 'locn'=0x3
p3: ''=0x0
time_waited: 0.093558 sec (sample interval: 0 sec)
[1 sample,
13:31:38]
waited for 'ASM file metadata operation', seq_num: 26286
p1: 'msgop'=0x2
p2: 'locn'=0x3
p3: ''=0x0
time_waited: 0.062413 sec (sample interval: 0 sec)
[70 samples, 13:30:30 -
13:31:37]
idle wait at each sample
---------------------------------------------------
Sampled Session History Summary:
longest_non_idle_wait: 'SGA: allocation forcing component growth'
[1 sample, 13:32:29 ]
time_waited: 0.103982 sec (sample interval: 0 sec)
---------------------------------------------------
----------------------------------------
kpoxc: mode=0 static=0 inReq=0 pendErrInRep=0 callUseSCN=0 nonReq=0
kpoxc: trace=0 roundTrip=0 errCode=0 ctl=0 eocs=0 disErr=0 dscnEnabled=0
temporary object counter: 0
last pdbid to increment: 0, last function to increment: (null)
BPS: empty
----------------------------------------
kghnospc()+4059 call kgh_invoke_alloc_cb 000000000 ? 000000000 ?
() 000000000 ? 000000000 ?
000000000 ? 000000000 ?
kghalo()+3274 call kghnospc() 000000000 ? 000000000 ?
000000000 ? 000000000 ?
000000000 ? 000000000 ?
ksmdacnk()+349 call kghalo() 000000000 ? 000000000 ?
000000000 ? 000000000 ?
000000000 ? 000000000 ?
ksmdget()+1533 call ksmdacnk() 000000000 ? 000000000 ?
000000000 ? 000000000 ?
000000000 ? 000000000 ?
kffmXpAlloc()+225 call ksmdget() 000000000 ? 000000000 ?
000000000 ? 000000000 ?
000000000 ? 000000000 ?
kffmAllocate()+672 call kffmXpAlloc() 000000000 ? 000000000 ?
000000000 ? 000000000 ?
000000000 ? 000000000 ?
kfnbMapOp()+263 call kffmAllocate() 000000000 ? 000000000 ?
000000000 ? 000000000 ?
000000000 ? 000000000 ?
kfnbRun()+9735 call kfnbMapOp() 000000000 ? 000000000 ?
000000000 ? 000000000 ?
000000000 ? 000000000 ?
ksbrdp()+1123 call kfnbRun() 000000000 ? 000000000 ?
000000000 ? 000000000 ?
000000000 ? 000000000 ?
opirip()+541 call ksbrdp() 000000000 ? 000000000 ?
==============================================
TOP 10 MEMORY USES FOR SGA HEAP SUB POOL 2
----------------------------------------------
"init_heap_kfsg 0001" 1706 MB 74% <<---
"free memory " 397 MB 17% <<---
"keomg: entry list 0004" 36 MB 2%
"KTSL subheap 0001" 19 MB 1%
"SO private sga 0001" 15 MB 1%
"KCRAHT Free Blocks 0001" 14 MB 1%
"ksunfy_meta 1 0001" 11 MB 0%
"ASH buffers 0001" 8192 KB 0%
"kcbi io desc slot 0004" 7407 KB 0%
"ges resource permanent 0001" 7221 KB 0%
-----------------------------------------
File_name:: xxxxxxxx1_asmb_234791_i544603.trc
grep -i 'kffmAllocate' *.trc|grep '315.1065446429'
CDB$ROOT(1):1:2021-02-28 13:32:05.050
:FB949C0E:KFF:kffm.c@3145:kffmAllocate():868:13513: mid 15455 group
[3.2918374675] file [315.1065446429] owner 0 size 3 rs 0x13
CDB$ROOT(1):1:2021-02-28 13:32:05.220
:FB94D5BC:KFF:kffm.c@3145:kffmAllocate():868:13513: mid 15456 group
[3.2918374675] file [315.1065446429] owner 0 size 3 rs 0x13
CDB$ROOT(1):1:2021-02-28 13:32:05.488
:FB95455D:KFF:kffm.c@3145:kffmAllocate():868:13513: mid 15459 group
[3.2918374675] file [315.1065446429] owner 0 size 3 rs 0x13
CDB$ROOT(1):1:2021-02-28 13:32:05.505
:FB9564AB:KFF:kffm.c@3145:kffmAllocate():868:13513: mid 15460 group
[3.2918374675] file [315.1065446429] owner 0 size 3 rs 0x13
CDB$ROOT(1):1:2021-02-28 13:32:20.723
:FBAC52C1:KFF:kffm.c@3145:kffmAllocate():868:13513: mid 15464 group
[3.2918374675] file [315.1065446429] owner 0 size 3 rs 0x13
CDB$ROOT(1):1:2021-02-28 13:32:20.773
:FBAC92A8:KFF:kffm.c@3145:kffmAllocate():868:13513: mid 15465 group
[3.2918374675] file [315.1065446429] owner 0 size 3 rs 0x13
grep -i 'kffmAllocate' *.trc|grep '272.1063748615'
CDB$ROOT(1):1:2021-02-28 13:32:04.756
:FB941091:KFF:kffm.c@3145:kffmAllocate():868:13513: mid 15454 group
[3.2918374675] file [272.1063748615] owner 0 size 12021759 rs 0x13
CDB$ROOT(1):1:2021-02-28 13:32:05.365
:FB950A26:KFF:kffm.c@3145:kffmAllocate():868:13513: mid 15457 group
[3.2918374675] file [272.1063748615] owner 0 size 12021759 rs 0x13
CDB$ROOT(1):1:2021-02-28 13:32:05.400
:FB95229E:KFF:kffm.c@3145:kffmAllocate():868:13513: mid 15458 group
[3.2918374675] file [272.1063748615] owner 0 size 12021759 rs 0x13
CDB$ROOT(1):1:2021-02-28 13:32:20.281
:FBABCBC0:KFF:kffm.c@3145:kffmAllocate():868:13513: mid 15461 group
[3.2918374675] file [272.1063748615] owner 0 size 12021759 rs 0x13
CDB$ROOT(1):1:2021-02-28 13:32:20.600
:FBAC29D1:KFF:kffm.c@3145:kffmAllocate():868:13513: mid 15462 group
[3.2918374675] file [272.1063748615] owner 0 size 12021759 rs 0x13
CDB$ROOT(1):1:2021-02-28 13:32:20.632
:FBAC35B3:KFF:kffm.c@3145:kffmAllocate():868:13513: mid 15463 group
[3.2918374675] file [272.1063748615] owner 0 size 12021759 rs 0x13
CDB$ROOT(1):1:2021-02-28 13:32:27.451
:FBB4CBE6:KFF:kffm.c@3145:kffmAllocate():868:13513: mid 15466 group
[3.2918374675] file [272.1063748615] owner 0 size 12021759 rs 0x13
CDB$ROOT(1):1:2021-02-28 13:32:27.738
:FBB53947:KFF:kffm.c@3145:kffmAllocate():868:13513: mid 15467 group
[3.2918374675] file [272.1063748615] owner 0 size 12021759 rs 0x13
CDB$ROOT(1):1:2021-02-28 13:32:27.772
:FBB54536:KFF:kffm.c@3145:kffmAllocate():868:13513: mid 15468 group
[3.2918374675] file [272.1063748615] owner 0 size 12021759 rs 0x13
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 |