If CDC performance becomes degraded when the configured MEMOPS are exhausted and PowerExchange Express CDC for Oracle must create spill files to free up resources, perform the following steps:

Ensure that the storage used for spill files is not the root cause of the performance degradation. Performance might be severely degraded if slow network storage is used for the spill files.
Modify the following parameters in the OPTIONS statement:
SPILLMAX=2097151. Using fewer spill files is more efficient.
SPILLFILEBUFFSZ=1024. Increase the file buffering for spill files to decrease physical I/O.
If the previous steps do not improve performance, consider increasing the MEMOPS parameter value in the OPTIONS statement of the PowerExchange Express CDC for Oracle configuration file to a level that is sufficient to process the change data volume in memory.

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.