Remove Parallel Hint In ECM CS Batch (Doc ID 2967301.1)

Last updated on AUGUST 16, 2023

Applies to:

Goal

Task 22 of type FCCDataMovement hangs in ECM CS Batch and the batch never completes. According to our DB Administrator this is due to the parallel hint in the SQL statement (see below). Please advise how to remove the Parallel hint for this task.

CREATE TABLE TEMP_501195531168 AS SELECT /*+ PARALLEL(4) */ FCC_CS_WATCHLIST.WATCHLIST_RECORD_ORIGIN,FCC_CS_WATCHLIST.WATCHLIST_RECORD_TYPE,FCC_CS_WATCHLIST.WATCHLIST_SUB_KEY,FCC_CS_WATCHLIST.WATCHLIST_KEY,FCC_CS_WATCHLIST.WATCHLIST_ID,FCC_CS_WATCHLIST.WATCHLIST_RISK_SCORE,FCC_CS_WATCHLIST.WATCHLIST_SKEY,FCC_CS_WATCHLIST.JSON_TXT,FCC_CS_WATCHLIST.WATCHLIST_PRIMARY_NAME,FCC_CS_WATCHLIST.FIC_MIS_DATE,FCC_CS_WATCHLIST.WATCHLIST_SUB_ID FROM ( SELECT DISTINCT FCC_CS_WATCHLIST.WATCHLIST_RECORD_TYPE, FCC_CS_WATCHLIST.WATCHLIST_SUB_KEY, FCC_CS_WATCHLIST.WATCHLIST_KEY, FCC_CS_WATCHLIST.WATCHLIST_ID FROM FCC_CS_WATCHLIST INNER JOIN FCC_CS_WATCHLIST_LOOKUP ON (FCC_CS_WATCHLIST_LOOKUP.WATCHLIST_ID = FCC_CS_WATCHLIST.WATCHLIST_ID AND FCC_CS_WATCHLIST_LOOKUP.WATCHLIST_RECORD_TYPE = FCC_CS_WATCHLIST.WATCHLIST_RECORD_TYPE AND FCC_CS_WATCHLIST_LOOKUP.WATCHLIST_KEY = FCC_CS_WATCHLIST.WATCHLIST_KEY AND FCC_CS_WATCHLIST_LOOKUP.WATCHLIST_SUB_KEY = FCC_CS_WATCHLIST.WATCHLIST_SUB_KEY) INNER JOIN FCC_EVENT_ENTITY_MAP ON FCC_CS_WATCHLIST_LOOKUP.WATCHLIST_SKEY = FCC_EVENT_ENTITY_MAP.N_ENTITY_SKEY AND FCC_EVENT_ENTITY_MAP.V_ENTITY_TYPE = 'CS_WATCHLIST_ID' WHERE FCC_EVENT_ENTITY_MAP.N_RUN_SKEY = 95531168 ) T INNER JOIN FCC_CS_WATCHLIST ON( T.WATCHLIST_RECORD_TYPE = FCC_CS_WATCHLIST.WATCHLIST_RECORD_TYPE AND T.WATCHLIST_SUB_KEY = FCC_CS_WATCHLIST.WATCHLIST_SUB_KEY AND T.WATCHLIST_KEY = FCC_CS_WATCHLIST.WATCHLIST_KEY AND T.WATCHLIST_ID = FCC_CS_WATCHLIST.WATCHLIST_ID) WHERE 1=1
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.