Return
-
Title
New and deprecated compare parameters since 8.0 -
Description
New and deprecated compare parameters since 8.0 -
Cause
N/A -
Resolution
New compare parameters in 8.5:- SP_DEQ_MALLOC:
This parameter is to be used for the Compare process on the source side to allocate memory usage
- SP_DEQ_PARALLELISM:
This parameter manages the select statement Degree of Parallelism hint- SP_DEQ_THREADS:
This parameter controls the number of processing threads used by the compare and repair commands- SP_DEQ_LOG_ROW_DATA:
This parameter directs the behavior of the compare command to log details for out-of-sync row dataDeprecated compare parametersList of deprecated parameters since version 8.0:- SP_DEQ_CHARACTERSET
- SP_DEQ_NCHAR_CHARACTERSET
- SP_DEQ_NLS_LANG
- SP_DEQ_NLS_LANG_SELECTOR
List of deprecated parameters since version 8.5:
- SP_DEQ_BATCHSIZE
- SP_DEQ_CONFIG_LINE_SIZE