*************************SQL Monitoring Report for faster run*************************

SQL Text
------------------------------
DELETE /*+ full(TAB1) */ FROM TAB1 TAB1 WHERE ETC = 'XX' AND ID = 3 AND OTCD = 'YY' AND PART_DT = :B1

Global Information
------------------------------
 Status                                 :  DONE                           
 Instance ID                            :  1                              
 SQL Execution ID                       :  16777233                       
 Execution Started                      :  03/30/2021 22:16:57            
 First Refresh Time                     :  03/30/2021 22:17:05            
 Last Refresh Time                      :  03/30/2021 22:30:07            
 Duration                               :  790s                           
 PLSQL Entry Ids (Object/Subprogram)    :  99136,10                       
 PLSQL Current Ids (Object/Subprogram)  :  99136,10                       

Binds
========================================================================================================================
| Name | Position | Type |                                            Value                                            |
========================================================================================================================
| :B1  |        1 | DATE | 03/30/2021 00:00:00                                                                         |
========================================================================================================================

Global Stats
==================================================================================
| Elapsed |   Cpu   |    IO    | Concurrency | Cluster  | Buffer | Read  | Read  |
| Time(s) | Time(s) | Waits(s) |  Waits(s)   | Waits(s) |  Gets  | Reqs  | Bytes |
==================================================================================
|     797 |      98 |      697 |        0.00 |     1.15 |     9M | 69379 |  67GB |
==================================================================================

SQL Plan Monitoring Details (Plan Hash Value=2458802412)
===================================================================================================================================================================
| Id |           Operation           |         Name         |  Rows   | Cost |   Time    | Start  | Execs |   Rows   | Read  | Read  | Activity | Activity Detail |
|    |                               |                      | (Estim) |      | Active(s) | Active |       | (Actual) | Reqs  | Bytes |   (%)    |   (# samples)   |
===================================================================================================================================================================
|  0 | DELETE STATEMENT              |                      |         |      |           |        |     1 |          |       |       |          |                 |
|  1 |   DELETE                      | TAB1                 |         |      |           |        |     1 |          |       |       |          |                 |
|  2 |    PARTITION RANGE SINGLE     |                      |       1 |    2 |           |        |     1 |          |       |       |          |                 |
|  3 |     TABLE ACCESS STORAGE FULL | TAB1                 |       1 |    2 |       789 |     +1 |     1 |        0 | 69379 |  67GB |          |                 |
===================================================================================================================================================================




********************SQL Monitoring Report for slower run ********************************

SQL Text
------------------------------
DELETE /*+ full(TAB1) */ FROM TAB1 TAB1 WHERE ETC = 'XX' AND ID = 3 AND OTCD = 'YY' AND PART_DT = :B1

Global Information
------------------------------
 Status                                 :  DONE                           
 Instance ID                            :  1                              
 SQL Execution ID                       :  16777234                       
 Execution Started                      :  03/31/2021 22:17:20            
 First Refresh Time                     :  03/31/2021 22:17:34            
 Last Refresh Time                      :  03/31/2021 22:48:00            
 Duration                               :  1840s                          
 PLSQL Entry Ids (Object/Subprogram)    :  99136,10                       
 PLSQL Current Ids (Object/Subprogram)  :  99136,10                       

Binds
========================================================================================================================
| Name | Position | Type |                                            Value                                            |
========================================================================================================================
| :B1  |        1 | DATE | 03/31/2021 00:00:00                                                                         |
========================================================================================================================

Global Stats
==================================================================================
| Elapsed |   Cpu   |    IO    | Concurrency | Cluster  | Buffer | Read  | Read  |
| Time(s) | Time(s) | Waits(s) |  Waits(s)   | Waits(s) |  Gets  | Reqs  | Bytes |
==================================================================================
|    1849 |     106 |     1741 |        0.00 |     2.09 |     9M | 68965 |  67GB |
==================================================================================

SQL Plan Monitoring Details (Plan Hash Value=2458802412)
===================================================================================================================================================================
| Id |           Operation           |         Name         |  Rows   | Cost |   Time    | Start  | Execs |   Rows   | Read  | Read  | Activity | Activity Detail |
|    |                               |                      | (Estim) |      | Active(s) | Active |       | (Actual) | Reqs  | Bytes |   (%)    |   (# samples)   |
===================================================================================================================================================================
|  0 | DELETE STATEMENT              |                      |         |      |           |        |     1 |          |       |       |          |                 |
|  1 |   DELETE                      | TAB1                 |         |      |           |        |     1 |          |       |       |          |                 |
|  2 |    PARTITION RANGE SINGLE     |                      |       1 |    2 |           |        |     1 |          |       |       |          |                 |
|  3 |     TABLE ACCESS STORAGE FULL | TAB1                 |       1 |    2 |      1841 |     +0 |     1 |        0 | 68965 |  67GB |          |                 |
===================================================================================================================================================================