Global Information ------------------------------ Status : DONE (ALL ROWS) Instance ID : 1 SQL Execution ID : 16777216 Execution Started : 12/24/2020 09:55:45 First Refresh Time : 12/24/2020 09:55:49 Last Refresh Time : 12/24/2020 10:02:56 Duration : 431s Module/Action : SQL*Plus/- Program : sqlplus.exe Fetch Calls : 2 Global Stats ===================================================================================================== | Elapsed | Cpu | IO | Cluster | Fetch | Buffer | Read | Read | Write | Write | Cell | | Time(s) | Time(s) | Waits(s) | Waits(s) | Calls | Gets | Reqs | Bytes | Reqs | Bytes | Offload | ===================================================================================================== | 453 | 58 | 395 | 0.00 | 2 | 57455 | 365K | 42GB | 2980 | 349MB | -2.04% | ===================================================================================================== SQL Plan Monitoring Details (Plan Hash Value=308020963) =========================================================================================================================================================================================================== | Id | Operation | Name | Rows | Cost | Time | Start | Execs | Rows | Read | Read | Write | Write | Mem | Temp | Activity | Activity Detail | | | | | (Estim) | | Active(s) | Active | | (Actual) | Reqs | Bytes | Reqs | Bytes | (Max) | (Max) | (%) | (# samples) | =========================================================================================================================================================================================================== | 0 | SELECT STATEMENT | | | | 216 | +216 | 1 | 3 | | | | | | | | | | 1 | NESTED LOOPS OUTER | | 3 | 17611 | 216 | +216 | 1 | 3 | | | | | | | | | | 2 | FILTER | | | | 428 | +4 | 1 | 3 | | | | | | | | | | 3 | HASH JOIN RIGHT OUTER | | 3 | 17606 | 431 | +2 | 1 | 2M | 365K | 42GB | 384 | 45MB | 1M | 391M | 100.00 | Cpu (34) | | | | | | | | | | | | | | | | | | direct path read temp (395) | | | | | | | | | | | | | | | | | | direct path write temp (1) | | 4 | TABLE ACCESS STORAGE FULL | BOS | 1M | 3274 | 1 | +4 | 1 | 1M | | | | | | | | | | 5 | TABLE ACCESS STORAGE FULL | COX | 2M | 3213 | 3 | +4 | 1 | 2M | | | | | | | | | | 6 | TABLE ACCESS BY INDEX ROWID | CS | 1 | 2 | 1 | +222 | 3 | 1 | | | | | | | | | | 7 | INDEX UNIQUE SCAN | CS_PK | 1 | 1 | 1 | +222 | 3 | 1 | 3 | 24576 | | | | | | | =========================================================================================================================================================================================================== Predicate Information (identified by operation id): --------------------------------------------------- 2 - filter("COX"."BI"=TO_NUMBER(:B1) OR "BOS"."BI"=TO_NUMBER(:B2) AND "BOS"."I_DT" IS NULL AND "COX"."CT3"='XXX') 3 - access("BOS"."OID"(+)=TO_NUMBER("COX"."OID") AND "BOS"."BI"(+)="COX"."BI") 7 - access("COX"."EID"="CS"."EID"(+))