Global Information
------------------------------
 Status              :  EXECUTING                    
 Instance ID         :  4                            
 SQL Execution ID    :  67108883                     
 Execution Started   :  01/23/2021 08:44:19          
 First Refresh Time  :  01/23/2021 08:44:23          
 Last Refresh Time   :  01/23/2021 08:56:59          
 Duration            :  761s                         
 Module/Action       :  JDBC Thin Client/-           
 Program             :  JDBC Thin Client             

Binds
========================================================================================================================
| Name | Position | Type |                                            Value                                            |
========================================================================================================================
| :1   |        1 | DATE | 07/26/2020 00:00:00                                                                         |
| :2   |        2 | DATE | 01/22/2021 00:00:00                                                                         |
| :3   |        3 | DATE | 07/26/2020 00:00:00                                                                         |
| :4   |        4 | DATE | 01/22/2021 00:00:00                                                                         |
========================================================================================================================

Global Stats
================================================================================
| Elapsed |   Cpu   |    IO    | Application | Buffer | Read | Read  |  Cell   |
| Time(s) | Time(s) | Waits(s) |  Waits(s)   |  Gets  | Reqs | Bytes | Offload |
================================================================================
|     809 |     373 |      436 |        0.19 |   738M |   6M |   5TB |  99.72% |
================================================================================

SQL Plan Monitoring Details (Plan Hash Value=2890488382)
========================================================================================================================================================================================================================
| Id    |              Operation               |           Name           |  Rows   | Cost |   Time    | Start  | Execs |   Rows   | Read | Read  |  Cell   | Mem  | Activity |       Activity Detail       | Progress |
|       |                                      |                          | (Estim) |      | Active(s) | Active |       | (Actual) | Reqs | Bytes | Offload |      |   (%)    |         (# samples)         |          |
========================================================================================================================================================================================================================
|     0 | SELECT STATEMENT                     |                          |         |      |           |        |     1 |          |      |       |         |      |          |                             |          |
|     1 |   SORT ORDER BY                      |                          |    1000 | 162M |           |        |     1 |          |      |       |         |      |          |                             |          |
|     2 |    HASH JOIN RIGHT OUTER             |                          |    1000 | 162M |           |        |     1 |          |      |       |         | 547K |          |                             |          |
|     3 |     VIEW                             |                          |       1 |   1M |           |        |     1 |          |      |       |         |      |          |                             |          |
|     4 |      HASH GROUP BY                   |                          |       1 |   1M |           |        |     1 |          |      |       |         |      |          |                             |          |
|     5 |       FILTER                         |                          |         |      |           |        |     1 |          |      |       |         |      |          |                             |          |
|     6 |        HASH JOIN                     |                          |       1 |   1M |         1 |     +4 |     1 |        0 |      |       |         |      |          |                             |          |
|     7 |         JOIN FILTER CREATE           | :BF0000                  |    1000 |   19 |         1 |     +4 |     1 |        2 |      |       |         |      |          |                             |          |
|     8 |          TABLE ACCESS STORAGE FULL   | GTT                      |    1000 |   19 |         1 |     +4 |     1 |        2 |      |       |         |      |          |                             |          |
|     9 |         JOIN FILTER USE              | :BF0000                  |   11120 |   1M |         1 |     +4 |     1 |        2 |      |       |         |      |          |                             |          |
|    10 |          PARTITION RANGE ALL         |                          |   11120 |   1M |         1 |     +4 |     1 |        2 |      |       |         |      |          |                             |          |
|    11 |           TABLE ACCESS STORAGE FULL  | TAB2                     |   11120 |   1M |         4 |     +2 |    28 |        2 | 5831 |   6GB |  99.10% |      |     0.53 | Cpu (2)                     |          |
|       |                                      |                          |         |      |           |        |       |          |      |       |         |      |          | cell smart table scan (2)   |          |
|    12 |     HASH JOIN RIGHT OUTER            |                          |    1000 | 161M |           |        |     1 |          |      |       |         | 174K |          |                             |          |
|    13 |      VIEW                            |                          |       1 | 161M |           |        |     1 |          |      |       |         |      |          |                             |          |
|    14 |       HASH GROUP BY                  |                          |       1 | 161M |       143 |   +370 |     1 |        0 |      |       |         | 519K |          |                             |          |
|    15 |        FILTER                        |                          |         |      |       143 |   +370 |     1 |        2 |      |       |         |      |          |                             |          |
| -> 16 |         HASH JOIN                    |                          |       1 | 161M |       755 |     +6 |     1 |        2 |      |       |         | 407K |          |                             |          |
|    17 |          JOIN FILTER CREATE          | :BF0001                  |    1000 |   19 |         1 |     +6 |     1 |        2 |      |       |         |      |          |                             |          |
|    18 |           TABLE ACCESS STORAGE FULL  | GTT                      |    1000 |   19 |         1 |     +6 |     1 |        2 |      |       |         |      |          |                             |          |
| -> 19 |          JOIN FILTER USE             | :BF0001                  |     18G | 161M |       755 |     +6 |     1 |     513K |      |       |         |      |          |                             |          |
| -> 20 |           PARTITION RANGE ITERATOR   |                          |     18G | 161M |       755 |     +6 |     1 |     513K |      |       |         |      |          |                             |          |
| -> 21 |            TABLE ACCESS STORAGE FULL | TAB1                     |     18G | 161M |       755 |     +6 |   169 |     513K |   6M |   1TB |  98.95% |   7M |    99.47 | Cpu (303)                   |     100% |
|       |                                      |                          |         |      |           |        |       |          |      |       |         |      |          | reliable message (4)        |          |
|       |                                      |                          |         |      |           |        |       |          |      |       |         |      |          | cell smart table scan (447) |          |
|    22 |      TABLE ACCESS STORAGE FULL       | GTT                      |    1000 |   19 |           |        |       |          |      |       |         |      |          |                             |          |
========================================================================================================================================================================================================================