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

Last updated on AUGUST 10, 2011

Applies to:

Oracle Server - Standard Edition - Version: 9.2.0.8 and later   [Release: 9.2 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: GEHUS5031, ospid: 5296:1468, machine: EC\GEHUS5031
            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



Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms