Global Stats
==============================================================================================================================================
| Elapsed |   Cpu   |    IO    | Application | Concurrency | Cluster  | PL/SQL  |  Other   | Buffer | Read | Read  | Write | Write |  Cell   |
| Time(s) | Time(s) | Waits(s) |  Waits(s)   |  Waits(s)   | Waits(s) | Time(s) | Waits(s) |  Gets  | Reqs | Bytes | Reqs  | Bytes | Offload |
==============================================================================================================================================
|   46393 |   15591 |    18354 |        0.01 |          57 |      253 |    0.00 |    12139 |   255M |  29M | 741GB |    2M | 417GB | -61.29% |
==============================================================================================================================================

SQL Plan Monitoring Details (Plan Hash Value=252959951)
==================================================================================================================================================================================================================================================================================
| Id   |                  Operation                  |            Name             |  Rows   | Cost |   Time    | Start  | Execs |   Rows   | Read | Read  | Write | Write |  Cell   | Mem  | Temp | Activity |                    Activity Detail                    | Progress |
|      |                                             |                             | (Estim) |      | Active(s) | Active |       | (Actual) | Reqs | Bytes | Reqs  | Bytes | Offload |      |      |   (%)    |                      (# samples)                      |          |
==================================================================================================================================================================================================================================================================================
|    0 | INSERT STATEMENT                            |                             |         |      |      3126 |    +27 |    33 |        0 |      |       |       |       |         |      |      |     0.44 | buffer busy waits (41)                                |          |
|      |                                             |                             |         |      |           |        |       |          |      |       |       |       |         |      |      |          | row cache lock (4)                                    |          |
|      |                                             |                             |         |      |           |        |       |          |      |       |       |       |         |      |      |          | Cpu (112)                                             |          |
|      |                                             |                             |         |      |           |        |       |          |      |       |       |       |         |      |      |          | enq: CR - block range reuse ckpt (2)                  |          |
|      |                                             |                             |         |      |           |        |       |          |      |       |       |       |         |      |      |          | enq: US - contention (20)                             |          |
|      |                                             |                             |         |      |           |        |       |          |      |       |       |       |         |      |      |          | reliable message (24)                                 |          |
|      |                                             |                             |         |      |           |        |       |          |      |       |       |       |         |      |      |          | cell single block physical read (2)                   |          |
|    1 |   PX COORDINATOR                            |                             |         |      |         2 |     +1 |    33 |        0 |      |       |       |       |         |      |      |     0.00 | os thread startup (2)                                 |          |
|    2 |    PX SEND QC (RANDOM)                      | :TQ10006                    |    532M |   2M |           |        |       |          |      |       |       |       |         |      |      |          |                                                       |          |
|    3 |     INDEX MAINTENANCE                       | TARGET_TAB                  |         |      |           |        |       |          |      |       |       |       |         |      |      |          |                                                       |          |
|    4 |      PX RECEIVE                             |                             |    532M |   2M |           |        |       |          |      |       |       |       |         |      |      |          |                                                       |          |
| -> 5 |       PX SEND RANGE                         | :TQ10005                    |    532M |   2M |         3 |  +1077 |    16 |        0 |      |       |       |       |         |      |      |          |                                                       |          |
| -> 6 |        LOAD AS SELECT                       |                             |         |      |      2595 |   +562 |    16 |       16 |  28M | 359GB |    1M | 224GB |         | 574M |      |    82.98 | gc cr grant 2-way (1)                                 |     100% |
|      |                                             |                             |         |      |           |        |       |          |      |       |       |       |         |      |      |          | gc current grant 2-way (224)                          |          |
|      |                                             |                             |         |      |           |        |       |          |      |       |       |       |         |      |      |          | gc current multi block request (7)                    |          |
|      |                                             |                             |         |      |           |        |       |          |      |       |       |       |         |      |      |          | gc current request (3)                                |          |
|      |                                             |                             |         |      |           |        |       |          |      |       |       |       |         |      |      |          | buffer busy waits (1)                                 |          |
|      |                                             |                             |         |      |           |        |       |          |      |       |       |       |         |      |      |          | log file switch completion (42)                       |          |
|      |                                             |                             |         |      |           |        |       |          |      |       |       |       |         |      |      |          | statement suspended, wait error to be cleared (12173) |          |
|      |                                             |                             |         |      |           |        |       |          |      |       |       |       |         |      |      |          | undo segment extension (3)                            |          |
|      |                                             |                             |         |      |           |        |       |          |      |       |       |       |         |      |      |          | Cpu (11338)                                           |          |
|      |                                             |                             |         |      |           |        |       |          |      |       |       |       |         |      |      |          | PX Deq: Table Q Get Keys (976)                        |          |
|      |                                             |                             |         |      |           |        |       |          |      |       |       |       |         |      |      |          | enq: FB - contention (9)                              |          |
|      |                                             |                             |         |      |           |        |       |          |      |       |       |       |         |      |      |          | cell list of blocks physical read (1)                 |          |
|      |                                             |                             |         |      |           |        |       |          |      |       |       |       |         |      |      |          | cell single block physical read (8114)                |          |
|      |                                             |                             |         |      |           |        |       |          |      |       |       |       |         |      |      |          | direct path read temp (5286)                          |          |
|      |                                             |                             |         |      |           |        |       |          |      |       |       |       |         |      |      |          | direct path write temp (149)                          |          |
|    7 |         SORT ORDER BY                       |                             |    532M |   2M |       825 |   +253 |    16 |     521M | 259K |  51GB |  259K |  51GB |         |      |      |     3.12 | Cpu (449)                                             |          |
|      |                                             |                             |         |      |           |        |       |          |      |       |       |       |         |      |      |          | direct path read temp (932)                           |          |
|      |                                             |                             |         |      |           |        |       |          |      |       |       |       |         |      |      |          | direct path write temp (61)                           |          |
|    8 |          PX RECEIVE                         |                             |    532M | 694K |       311 |   +253 |    16 |     521M |      |       |       |       |         |      |      |     0.11 | Cpu (49)                                              |          |
|    9 |           PX SEND PARTITION (KEY)           | :TQ10004                    |    532M | 694K |       825 |   +253 |    16 |     521M |      |       |       |       |         |      |      |     0.49 | Cpu (227)                                             |          |
|   10 |            HASH JOIN BUFFERED               |                             |    532M | 694K |      1010 |    +68 |    16 |     521M | 290K |  69GB |  290K |  69GB |         |      |      |     4.20 | Cpu (795)                                             |     100% |
|      |                                             |                             |         |      |           |        |       |          |      |       |       |       |         |      |      |          | direct path read temp (1142)                          |          |
|      |                                             |                             |         |      |           |        |       |          |      |       |       |       |         |      |      |          | direct path write temp (1)                            |          |
|   11 |             PX RECEIVE                      |                             |     12M | 3331 |         3 |    +68 |    16 |      12M |      |       |       |       |         |      |      |          |                                                       |          |
|   12 |              PX SEND HASH                   | :TQ10002                    |     12M | 3331 |         3 |    +68 |    16 |      12M |      |       |       |       |         |      |      |          |                                                       |          |
|   13 |               PX BLOCK ITERATOR             |                             |     12M | 3331 |         3 |    +68 |    16 |      12M |      |       |       |       |         |      |      |          |                                                       |          |
|   14 |                TABLE ACCESS STORAGE FULL    | SOURCE_TAB2                 |     12M | 3331 |         3 |    +68 |   208 |      12M | 1583 |   1GB |       |       |  84.57% |      |      |          |                                                       |          |
|   15 |             PX RECEIVE                      |                             |    532M | 690K |       186 |    +69 |    16 |     526M |      |       |       |       |         |      |      |     0.22 | Cpu (101)                                             |          |
|      |                                             |                             |         |      |           |        |       |          |      |       |       |       |         |      |      |          | PX Deq: Table Q Normal (2)                            |          |
|   16 |              PX SEND HASH                   | :TQ10003                    |    532M | 690K |       187 |    +68 |    16 |     526M |      |       |       |       |         |      |      |     0.37 | Cpu (170)                                             |          |
|   17 |               HASH JOIN BUFFERED            |                             |    532M | 690K |       252 |     +3 |    16 |     526M | 313K |  74GB |  313K |  74GB |         |      |      |     6.99 | Cpu (785)                                             |          |
|      |                                             |                             |         |      |           |        |       |          |      |       |       |       |         |      |      |          | direct path read temp (2302)                          |          |
|      |                                             |                             |         |      |           |        |       |          |      |       |       |       |         |      |      |          | direct path write temp (144)                          |          |
|   18 |                PX RECEIVE                   |                             |    453M | 314K |        24 |     +3 |    16 |     461M |      |       |       |       |         |      |      |     0.06 | Cpu (28)                                              |          |
|   19 |                 PX SEND HASH                | :TQ10000                    |    453M | 314K |        24 |     +3 |    16 |     461M |      |       |       |       |         |      |      |     0.15 | Cpu (68)                                              |          |
|   20 |                  PX BLOCK ITERATOR          |                             |    453M | 314K |        23 |     +4 |    16 |     461M |      |       |       |       |         |      |      |          |                                                       |          |
|   21 |                   TABLE ACCESS STORAGE FULL | SOURCE_TAB2                 |    453M | 314K |        24 |     +3 |   207 |     461M | 145K | 127GB |       |       |  86.81% |      |      |     0.05 | Cpu (16)                                              |          |
|      |                                             |                             |         |      |           |        |       |          |      |       |       |       |         |      |      |          | cell smart table scan (5)                             |          |
|   22 |                PX RECEIVE                   |                             |    578M | 150K |        43 |    +26 |    16 |     578M |      |       |       |       |         |      |      |     0.14 | Cpu (65)                                              |          |
|   23 |                 PX SEND HASH                | :TQ10001                    |    578M | 150K |        43 |    +26 |    16 |     578M |      |       |       |       |         |      |      |     0.27 | Cpu (123)                                             |          |
|   24 |                  PX BLOCK ITERATOR          |                             |    578M | 150K |        43 |    +26 |    16 |     578M |      |       |       |       |         |      |      |          |                                                       |          |
|   25 |                   TABLE ACCESS STORAGE FULL | SOURCE_TAB3                 |    578M | 150K |        44 |    +25 |   215 |     578M | 113K |  61GB |       |       |  13.79% |      |      |     0.41 | Cpu (45)                                              |          |
|      |                                             |                             |         |      |           |        |       |          |      |       |       |       |         |      |      |          | cell smart table scan (143)                           |          |
==================================================================================================================================================================================================================================================================================