Error ORA-04031 in the Large Pool with Memory Type "CTWR dba buffer" and/or ORA-29770
(Doc ID 2631655.1)
Last updated on JULY 01, 2020
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 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