Global Information
------------------------------
 Status              :  EXECUTING                    
 Instance ID         :  1                            
 SQL Execution ID    :  16777218                     
 Execution Started   :  12/24/2020 04:54:10          
 First Refresh Time  :  12/24/2020 04:54:14          
 Last Refresh Time   :  12/24/2020 05:16:33          
 Duration            :  1343s                        
 Module/Action       :  SQL*Plus/-                   
 Program             :  sqlplus.exe                  
 Fetch Calls         :  1                            


Global Stats
========================================================================================================
| Elapsed |   Cpu   |    IO    | Application | Fetch | Buffer | Read | Read  | Write | Write |  Cell   |
| Time(s) | Time(s) | Waits(s) |  Waits(s)   | Calls |  Gets  | Reqs | Bytes | Reqs  | Bytes | Offload |
========================================================================================================
|    1403 |     154 |     1248 |        0.00 |     1 |  81172 | 919K | 106GB |  7113 | 834MB |  -1.01% |
========================================================================================================

SQL Plan Monitoring Details (Plan Hash Value=2475526405)
===================================================================================================================================================================================================================================
| 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 | SELECT STATEMENT                 |                 |         |       |      1336 |     +8 |     1 |        2 |       |       |       |       |         |     |      |          |                              |          |
| -> 1 |   VIEW                           | VW_FOJ_0        |      2M | 43497 |      1336 |     +8 |     1 |        2 |       |       |       |       |         |     |      |     0.07 | Cpu (1)                      |          |
| -> 2 |    HASH JOIN FULL OUTER          |                 |      2M | 43497 |      1343 |     +1 |     1 |       1M |  851K |  97GB |  2981 | 349MB |         |  1M | 560M |    93.51 | Cpu (73)                     |      44% |
|      |                                  |                 |         |       |           |        |       |          |       |       |       |       |         |     |      |          | direct path read temp (1177) |          |
|      |                                  |                 |         |       |           |        |       |          |       |       |       |       |         |     |      |          | direct path write temp (3)   |          |
|    3 |     TABLE ACCESS STORAGE FULL    | BOS             |      1M |  3274 |         1 |     +4 |     1 |       1M |       |       |       |       |         |     |      |          |                              |          |
|    4 |     VIEW                         |                 |      2M | 16677 |        85 |     +6 |     1 |       2M |       |       |       |       |         |     |      |          |                              |          |
|    5 |      VIEW                        | VW_FOJ_1        |      2M | 16677 |        85 |     +6 |     1 |       2M |       |       |       |       |         |     |      |          |                              |          |
|    6 |       HASH JOIN FULL OUTER       |                 |      2M | 16677 |        88 |     +3 |     1 |       2M | 66794 |   8GB |  2493 | 292MB |         |     |      |     6.42 | Cpu (9)                      |     100% |
|      |                                  |                 |         |       |           |        |       |          |       |       |       |       |         |     |      |          | direct path read temp (76)   |          |
|      |                                  |                 |         |       |           |        |       |          |       |       |       |       |         |     |      |          | direct path write temp (1)   |          |
|    7 |        TABLE ACCESS STORAGE FULL | CS              |    948K |  2683 |         3 |     +4 |     1 |     948K |   218 | 131MB |       |       |  37.50% |     |      |          |                              |          |
|    8 |        TABLE ACCESS STORAGE FULL | COX             |      2M |  3213 |         3 |     +6 |     1 |       2M |   402 | 222MB |       |       |  24.24% |     |      |          |                              |          |
===================================================================================================================================================================================================================================