ALTER SESSION ENABLE PARALLEL DML;

 update /*+ PARALLEL(24) */ BI_REP.REP_WO_DETAIL T  set     (   
T.LATEST_FLAG   ) =    (    select S.LATEST_FLAG    from 
BI_STG.I$_REP_WO_DETAIL S    where T.SNAPSHOT_DATE 
=S.SNAPSHOT_DATE         )  where exists (    select  'X'    from 
BI_STG.I$_REP_WO_DETAIL T2    where T2.SNAPSHOT_DATE 
=T.SNAPSHOT_DATE   );

Plan hash value: 1677052872
 
-------------------------------------------------------------------------------------------------------------------------------------------
| Id  | Operation                            | Name                  | Rows  | Bytes | Cost (%CPU)| Time     |    TQ  |IN-OUT| PQ Distrib |
-------------------------------------------------------------------------------------------------------------------------------------------
|   0 | UPDATE STATEMENT                     |                       |       |       |  5482K(100)|          |        |      |            |
|   1 |  UPDATE                              | REP_WORP_WO_DETAIL    |       |       |            |          |        |      |            |
|   2 |   PX COORDINATOR                     |                       |       |       |            |          |        |      |            |
|   3 |    PX SEND QC (RANDOM)               | :TQ10001              |  1822K|   112M| 14448   (1)| 00:00:01 |  Q1,01 | P->S | QC (RAND)  |
|*  4 |     HASH JOIN RIGHT SEMI             |                       |  1822K|   112M| 14448   (1)| 00:00:01 |  Q1,01 | PCWP |            |
|   5 |      BUFFER SORT                     |                       |       |       |            |          |  Q1,01 | PCWC |            |
|   6 |       PX RECEIVE                     |                       |     1 |    11 |     1   (0)| 00:00:01 |  Q1,01 | PCWP |            |
|   7 |        PX SEND BROADCAST             | :TQ10000              |     1 |    11 |     1   (0)| 00:00:01 |        | S->P | BROADCAST  |
|   8 |         INDEX FULL SCAN              | I$_REP_WO_DETAIL |     1 |    11 |     1   (0)| 00:00:01 |        |      |            |
|   9 |      PX BLOCK ITERATOR               |                       |    11M|   570M| 14446   (1)| 00:00:01 |  Q1,01 | PCWC |            |
|* 10 |       TABLE ACCESS FULL              | REP_WORP_WO_DETAIL    |    11M|   570M| 14446   (1)| 00:00:01 |  Q1,01 | PCWP |            |
|  11 |   TABLE ACCESS BY INDEX ROWID BATCHED| I$_REP_WORP_WO_DETAIL |     1 |    13 |     2   (0)| 00:00:01 |        |      |            |
|* 12 |    INDEX RANGE SCAN                  | I$_REP_WORP_WO_DETAIL |     1 |       |     1   (0)| 00:00:01 |        |      |            |
-------------------------------------------------------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   4 - access("T2"."SNAPSHOT_DATE"="T"."SNAPSHOT_DATE")
  10 - access(:Z>=:Z AND :Z<=:Z)
  12 - access("S"."SNAPSHOT_DATE"=:B1)
 
Note
-----
   - dynamic statistics used: dynamic sampling (level=AUTO)
   - Degree of Parallelism is 24 because of hint
   - PDML disabled because single fragment or non partitioned table used