Global Information ------------------------------ Status : EXECUTING 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:26:15 Duration : 1080s Global Stats ================================================================================== | Elapsed | Cpu | IO | Buffer | Read | Read | Write | Write | Cell | | Time(s) | Time(s) | Waits(s) | Gets | Reqs | Bytes | Reqs | Bytes | Offload | ================================================================================== | 1124 | 120 | 1004 | 81196 | 808K | 92GB | 7100 | 832MB | -2.04% | ================================================================================== 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 | Progress | | | | | (Estim) | | Active(s) | Active | | (Actual) | Reqs | Bytes | Reqs | Bytes | | | (%) | (# samples) | | ======================================================================================================================================================================================================================= | 0 | SELECT STATEMENT | | | | | | 1 | | | | | | | | | | | | -> 1 | VIEW | VW_FOJ_0 | 2M | 42883 | 1072 | +8 | 1 | 0 | | | | | | | | | | | -> 2 | HASH JOIN FULL OUTER | | 2M | 42883 | 1079 | +2 | 1 | 390K | 147K | 17GB | 2979 | 349MB | 1M | 559M | 17.55 | Cpu (7) | 8% | | | | | | | | | | | | | | | | | | direct path read temp (180) | | | | | | | | | | | | | | | | | | | 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 | | | 82.45 | 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 | | | | | | | | | | ======================================================================================================================================================================================================================= 1 - filter(("A3"."BID1"=:B1 OR ("A2"."BI"=:B2 AND "A2"."I_DT" IS NULL AND (("A3"."BID1" IS NOT NULL AND "A3"."CT3"='XXX') OR ("A3"."BID1" IS NULL AND "A3"."CT3"='YYY'))))) 2 - access("A2"."BI"="A3"."BID1" AND "A2"."OID"=TO_NUMBER("A3"."OID2")) 6 - access("A5"."EID"="A4"."EID")