If the memory that PowerExchange Express CDC for Oracle uses to stage change records becomes full, for example, because of large UOWs or a high transaction volume, PowerExchange Express CDC for Oracle can spill additional change records to a temporary spill file on disk. If CDC performance becomes degraded, increase the MEMOPS parameter value in the OPTIONS statement of the PowerExchange Express CDC for Oracle configuration file to a level that is sufficient for the change data volume.

If you use continuous extraction mode, minimize the size of the CDCT file. The CDCT file contains information about PowerExchange Logger log files. PowerExchange reads the CDCT file each time the interval that is specified in the FILEWAIT parameter of the CAPX CAPI_CONNECTION statement elapses. If a CDCT file is large, PowerExchange read operations can result in a high level of I/O activity, increased use of system resources, and increased extraction latency. To manage the CDCT file size, use the COND_CDCT_RET_P statement in the pwxccl.cfg configuration file for the PowerExchange Logger.