Remove parallel hint for Oracle target

[Michael_Litz]

Environment

• Replicate
• Oracle Target
• Internal Parameter

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

Why you may want to remove the parallel hint.

Oracle target has an internal parameter that defaults to "Parallel Mode" which means that queries will be run in Parallel execution can cause delays and performance issues when the task is issuing Updates and Deletes to the target.

Example of the query statement beginning.

DELETE /*+ PARALLEL .....

How to remove parallel hint for Oracle target.

There is an internal parameter named bulkUseParallel, add that internal parameter in your target endpoint then uncheck the value and retest.

NOTE: Please stop/resume task for that change to take effect