My Oracle Support Banner

Error ORA-04031 in the Large Pool with Memory Type "CTWR dba buffer" and/or ORA-29770 (Doc ID 2631655.1)

Last updated on OCTOBER 06, 2021

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.



Received error ORA-04031 in "large pool" with memory type "CTWR dba buffer". For example,

ORA-04031: unable to allocate ###### bytes of shared memory ("large pool","unknown object","large pool","CTWR dba buffer")


ORA-29770 LMS hangs showing function kcllwr in the call stack.
A hang example is that LMS0 was waiting for logging Block Written Records (BWR)
when got blocked in CTWR buffer resize with this Call Stack example:
krccall <- krcrsz <- krcpwbs <- kcrfw_redo_gen_ext <-kcllwr <-kclpto <- kjmsm <- ksbrdp
and LMHB kills LMS process


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.