SQL Monitoring Report

Global Information
------------------------------
 Status                                 :  EXECUTING                                               
 Instance ID                            :  1                                                       
 Session                                :  APPS (4311:27945)                                       
 SQL ID                                 :  3zkuqckakdbsb                                           
 SQL Execution ID                       :  16777216                                                
 Execution Started                      :  10/25/2021 07:12:33                                     
 First Refresh Time                     :  10/25/2021 07:12:39                                     
 Last Refresh Time                      :  10/25/2021 10:03:37                                     
 Duration                               :  10266s                                                  
 Module/Action                          :  
 Service                                :  SPPPRD                                                  
 Program                                :                  
 PLSQL Entry Ids (Object/Subprogram)    :  7282349,2                                               
 PLSQL Current Ids (Object/Subprogram)  :  7282349,2                                               

Global Stats
======================================================================
| Elapsed |   Cpu   |    IO    | Concurrency | Buffer | Read | Read  |
| Time(s) | Time(s) | Waits(s) |  Waits(s)   |  Gets  | Reqs | Bytes |
======================================================================
|   10270 |   10270 |     0.01 |        0.01 |   665M |   19 | 152KB |
======================================================================

SQL Plan Monitoring Details (Plan Hash Value=3179817390)
===================================================================================================================================================================================================
| Id   |                 Operation                 |             Name             |  Rows   | Cost |   Time    | Start  | Execs |   Rows   | Read | Read  | Activity | Activity Detail | Progress |
|      |                                           |                              | (Estim) |      | Active(s) | Active |       | (Actual) | Reqs | Bytes |   (%)    |   (# samples)   |          |
===================================================================================================================================================================================================
| -> 0 | UPDATE STATEMENT                          |                              |         |      |     10261 |     +6 |     1 |        0 |      |       |          |                 |          |
| -> 1 |   UPDATE                                  | XXIM01T_SPP_PLAN_EXTRACT_TAB |         |      |     10261 |     +6 |     1 |        0 |      |       |          |                 |          |
| -> 2 |    NESTED LOOPS ANTI                      |                              |       1 |    6 |     10261 |     +6 |     1 |    25727 |      |       |          |                 |          |
| -> 3 |     TABLE ACCESS FULL                     | XXIM01T_SPP_PLAN_EXTRACT_TAB |       1 |    2 |     10261 |     +6 |     1 |    86389 |      |       |          |                 |      20% |
| -> 4 |     VIEW PUSHED PREDICATE                 | VW_SQ_1                      |       1 |    4 |     10261 |     +6 | 86389 |    60661 |      |       |          |                 |          |
| -> 5 |      NESTED LOOPS                         |                              |       1 |    4 |     10261 |     +6 | 86389 |    60661 |      |       |          |                 |          |
| -> 6 |       TABLE ACCESS BY INDEX ROWID BATCHED | MSC_TRADING_PARTNERS         |       1 |    4 |     10261 |     +6 | 86389 |    86389 |      |       |          |                 |          |
| -> 7 |        INDEX SKIP SCAN                    | MSC_TRADING_PARTNERS_U2      |       1 |    3 |     10261 |     +6 | 86389 |    86389 |      |       |          |                 |          |
| -> 8 |       INDEX FULL SCAN                     | XXINV01W_ITEMSS_SPP360_N1    |       1 |      |     10266 |     +1 | 86389 |    60661 |   19 | 152KB |          |                 |          |
===================================================================================================================================================================================================