My Oracle Support Banner

ORA-04031 "KSFQ Buffers" ksmlgpalloc (Doc ID 453521.1)

Last updated on MAY 19, 2021

Applies to:

Oracle Database - Standard Edition - Version and later
Oracle 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.


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




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

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