ORA-04031 "KSFQ Buffers" ksmlgpalloc
(Doc ID 453521.1)
Last updated on MAY 19, 2021
Applies to:
Oracle Database - Standard Edition - Version 9.2.0.8 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
-- Problem Statement:
Getting ORA-4031 in the alert log file:
ORA-04031: unable to allocate 532524 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","KSFQ Buffers")
...
SO: 80355EA8, type: 4, owner: 802FB928, flag: INIT/-/-/0x00
(session) trans: 00000000, creator: 802FB928, flag: (41) USR/- BSY/-/-/-/-/-
DID: 0001-0095-00000022, short-term DID: 0000-0000-00000000
txn branch: 00000000
oct: 0, prv: 0, sql: 8F21F578, psql: 00000000, user: 0/SYS
O/S info: user: SYSTEM, term: <terminal>, ospid: 5296:1468, machine: <machine>
program: rman.exe
client info: rman channel=ch1
application name: backup archivelog: ch1, hash value=3567860541
action name: 0000106 STARTED, hash value=3757870881
last wait for 'latch free' blocking sess=0x0 seq=1234 wait_time=332
address=8b6ca86c, number=9d, tries=0
temporary object counter: 0
...No current library cache object being loaded
...No instantiation object
...
Analysis of callstack
-------------------------------
ksm_4031_dump <- ksmasg <- kghnospc <- kghalo <- ksmlgpalloc <- ksfqbalo <- ksfqbcre <- ksfqxc <- ksfqxcrx <- ksfqxcre <- krbbpc <- krbibpc <- pevm_icd_call_comm <- pfrrun <- pricar <- pricbr <- prient2 <- prient <- kkxrpc <- kporpc <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o <- opimai
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 |