When the parallel hint is specified in Compare command, the hint is put ahead of 'distinct' keyword.
select /*+ parallel(AC_DDTLACT_IT 4) full(AC_DDTLACT_IT) */ distinct
rowid,"CU_INGNO","ACO_TY","MNBR_CODE","ACO_DATE","ACO_CODE","BDD_BAL","TODAY_BAL",
"CRCT_OAMT_GSUM_AMT","LAST_CHNG_DTIM" from "DBOWN"."AC_DDTLACT_IT" PARTITION ("AC_DDTLACT_2015_02")
where ROWID IN (SELECT OOS_ROWID FROM SHAREPLEX_DATAEQUATOR_UPD_TEMP ) order by 2, 3, 4, 5, 6
As a result, the hint doesn't work as expected in Oracle.
This is a product defect.
It should be shown like below.
select distinct /*+ parallel(AC_DDTLACT_IT 4) full(AC_DDTLACT_IT) */
Workaround:
None.
Status:
Resolved in hotfix(ST110874). Contact Support to get the hotfix.
