CTWR Process Raises ORA-4031 ("large pool" ... "Krcc Extent Chunk")
(Doc ID 738424.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.3 - Release: 10.1 to 10.2
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)
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
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;
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