PowerExchange Express CDC for Oracle Performance Considerations
PowerExchange Express CDC for Oracle Performance Considerations
PowerExchange Express CDC for Oracle processing of large transactions can degrade performance.
If CDC performance becomes degraded when the configured maximum redo log records in the MEMOPS parameter is exhausted and PowerExchange Express CDC for Oracle creates 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 SPILLMAX and SPILLFILEBUFFSZ parameters in the OPTIONS statement.
SPILLMAX=2097151. Reduce the number of spill files to improve efficiency.
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.
For more information, see the "Express CDC for Oracle" chapter in the
PowerExchange CDC Guide for Linux, UNIX, and Windows