CTWR Process Raises ORA-4031 ("large pool" ... "Krcc Extent Chunk") (Doc ID 738424.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.3 - Release: 10.1 to 10.2

Symptoms

The Oracle CTWR process is intermittently generating Trace files named "<SID>_ctwr_<PID>.trc" in whatever folder you have chosen to be your <background_dump_dest>.

In all cases, the trace files contain 4031 Diagnostic Dumps with:

 Allocation request for: krcc extent chunk
 ...
 HEAP DUMP heap name="large pool"
 OSD pid info: ... process pid: ..., image: ... (CTWR)

Call Stack:
 ksedst <- ksm_4031_dump <- ksmasg <- kghnospc <- kghalo  <- ksmc_large_pool_all
 <- krccea <- oc <- krccgb <- krccread <- krcchg <- krcptmo <- ksbcti <- ksbabs <- krcpabs
 <- ksbrdp <- opirip <- opidrv <- sou2o <- opimai_real <- main

Changes

Block Change Tracking has been turned on via the following SQL command:

SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '<file_path>;

Additionally, the following query is returning a row:

SQL> SELECT * FROM V$BLOCK_CHANGE_TRACKING;

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