-
Title
Compare server Oracle 11.1.0.6 to 11.2.0.2 do not support SELECT with a parallel hint. Set the SP_DEQ_PARALLELISM parameter to 0 for those Oracle versions -
Description
The following warning messages are observed when running a compare:
sp_ctrl> show log reverse
Info 2016-12-09 12:09:58.737561 16219 1 Compare server exited normally, pad = 17211 [sp_desvr]
Warning 2016-12-09 12:09:32.781480 17211 1 Compare server: Oracle 11.1.0.6 to 11.2.0.2 do not support SELECT with a parallel hint. Set the SP_DEQ_PARALLELISM parameter to 0 for those Oracle versions [sp_desvr] [module deq]
Info 2016-12-09 12:09:32.523961 17211 1 Compare server completed
-
Cause
The parallelism is not supported for Oracle versions 11.1.0.6 thru 11.2.0.2.
-
Resolution
The Oracle versions 11.1.0.6 to 11.2.0.2 does not support the use of parallelism in compare/repair by way of setting the parameter SP_DEQ_PARALLELISM or using the option PARALLELISM in compare/repair commands.
You can set the following parameter on sp_ctrl on source and target:
sp_ctrl>set param SP_DEQ_PARALLELISM 0
You can then run another compare/repair.
-
Additional Information
The parallelism can speed up compare/repair. The parameter SP_DEQ_PARALLELISM or the compare/repair command option "PARALLELISM" can be set to define the degree of parallelism to be used. For details please refer to SharePlex Reference Guide.