Load dim data running long RPAS V15 AP

Hi All,

We have our load dim data utility as part of load_hier batch job. Its running for more than 3 hours. DBA says there is no change in Exec plan and still job is running long.The parallel sessions of the Job were running below query and blocking themselves.

DELETE

FROM    rp_g_prod_s stg1

WHERE   stg1.skup IN

        (

                SELECT DISTINCT skup

                FROM    rp_g_prod_s_err

                WHERE   error_desc <> 'WDUP: Duplicated Record'

        )

        OR

        (

                stg1.skup IN

                (

                        SELECT DISTINCT skup

                        FROM    rp_g_prod_s_err

                        WHERE   error_desc = 'WDUP: Duplicated Record'

                )

                AND stg1.rowid NOT IN