Global Information
------------------------------
 Status              :  DONE (ALL ROWS)               
 Instance ID         :  1                             
 SQL Execution ID    :  16777403                      
 Execution Started   :  12/22/2020 10:08:16           
 First Refresh Time  :  12/22/2020 10:08:20           
 Last Refresh Time   :  12/22/2020 10:48:36           
 Duration            :  2420s                         
 Fetch Calls         :  2                             


Global Stats
==========================================================================================
| Elapsed |   Cpu   |    IO    | Fetch | Buffer | Read | Read  | Write | Write |  Cell   |
| Time(s) | Time(s) | Waits(s) | Calls |  Gets  | Reqs | Bytes | Reqs  | Bytes | Offload |
==========================================================================================
|    2528 |     275 |     2253 |     2 |  81196 |   2M | 222GB |  7100 | 832MB |  -1.01% |
==========================================================================================

SQL Plan Monitoring Details (Plan Hash Value=2475526405)
==============================================================================================================================================================================================================
| Id |            Operation             |      Name       |  Rows   | Cost  |   Time    | Start  | Execs |   Rows   | Read | Read  | Write | Write |  Mem  | Temp  | Activity |       Activity Detail        |
|    |                                  |                 | (Estim) |       | Active(s) | Active |       | (Actual) | Reqs | Bytes | Reqs  | Bytes | (Max) | (Max) |   (%)    |         (# samples)          |
==============================================================================================================================================================================================================
|  0 | SELECT STATEMENT                 |                 |         |       |      2413 |     +8 |     1 |        2 |      |       |       |       |       |       |          |                              |
|  1 |   VIEW                           | VW_FOJ_0        |      2M | 42883 |      2413 |     +8 |     1 |        2 |      |       |       |       |       |       |          |                              |
|  2 |    HASH JOIN FULL OUTER          |                 |      2M | 42883 |      2419 |     +2 |     1 |       2M |   1M | 147GB |  2979 | 349MB |    1M |  559M |    63.23 | Cpu (89)                     |
|    |                                  |                 |         |       |           |        |       |          |      |       |       |       |       |       |          | direct path read temp (1436) |
|    |                                  |                 |         |       |           |        |       |          |      |       |       |       |       |       |          | direct path write temp (2)   |
|  3 |     TABLE ACCESS STORAGE FULL    | BOS             |      1M |  3044 |         1 |     +4 |     1 |       1M |      |       |       |       |       |       |          |                              |
|  4 |     VIEW                         |                 |      2M | 16655 |       888 |     +8 |     1 |       2M |      |       |       |       |       |       |          |                              |
|  5 |      VIEW                        | VW_FOJ_1        |      2M | 16655 |       888 |     +8 |     1 |       2M |      |       |       |       |       |       |          |                              |
|  6 |       HASH JOIN FULL OUTER       |                 |      2M | 16655 |       892 |     +4 |     1 |       2M | 661K |  76GB |  2583 | 303MB |    1M |  372M |    36.77 | Cpu (56)                     |
|    |                                  |                 |         |       |           |        |       |          |      |       |       |       |       |       |          | direct path read temp (829)  |
|    |                                  |                 |         |       |           |        |       |          |      |       |       |       |       |       |          | direct path write temp (3)   |
|  7 |        TABLE ACCESS STORAGE FULL | CS              |    944K |  2683 |         3 |     +4 |     1 |     948K |      |       |       |       |       |       |          |                              |
|  8 |        TABLE ACCESS STORAGE FULL | COX             |      2M |  3213 |         3 |     +6 |     1 |       2M |      |       |       |       |       |       |          |                              |
==============================================================================================================================================================================================================