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 | ====================================================================================================== | 66 | 23 | 43 | 0.03 | 1 | 113K | 89285 | 10GB | 8685 | 1GB | -17.65% | ====================================================================================================== SQL Plan Monitoring Details (Plan Hash Value=3656565968) ======================================================================================================================================================================================================================== | 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 | | | | | | 1 | | | | | | | | | | | 1 | VIEW | | 3 | 87118 | | | 1 | | | | | | | | | | | 2 | UNION-ALL | | | | | | 1 | | | | | | | | | | | 3 | FILTER | | | | | | 1 | | | | | | | | | | | 4 | HASH JOIN OUTER | | 2 | 67231 | 61 | +1 | 1 | 0 | | | 2721 | 319MB | 923K | 536M | 1.67 | Cpu (1) | | 5 | TABLE ACCESS STORAGE FULL | BOS | 1M | 3044 | 1 | +4 | 1 | 1M | | | | | | | | | | 6 | VIEW | | 3M | 27259 | 58 | +4 | 1 | 2M | | | | | | | | | | 7 | UNION-ALL | | | | 58 | +4 | 1 | 2M | | | | | | | 1.67 | Cpu (1) | | 8 | HASH JOIN OUTER | | 1M | 16676 | 24 | +3 | 1 | 1M | 32233 | 4GB | | | 2M | 373M | 36.67 | Cpu (1) | | | | | | | | | | | | | | | | | | direct path read temp (21) | | 9 | TABLE ACCESS STORAGE FULL | CS | 948K | 2683 | 3 | +2 | 1 | 948K | | | | | | | 1.67 | Cpu (1) | | 10 | TABLE ACCESS STORAGE FULL | COX | 2M | 3213 | 1 | +4 | 1 | 2M | | | | | | | | | | 11 | HASH JOIN RIGHT ANTI | | 2M | 10583 | 36 | +26 | 1 | 456K | 52670 | 6GB | 1758 | 206MB | 2M | 231M | 56.67 | Cpu (7) | | | | | | | | | | | | | | | | | | direct path read temp (27) | | 12 | INDEX STORAGE FAST FULL SCAN | CS_PK | 948K | 410 | 2 | +25 | 1 | 948K | 3285 | 27MB | | | | | 1.67 | gc cr multi block request (1) | | 13 | TABLE ACCESS STORAGE FULL | COX | 2M | 3213 | 3 | +26 | 1 | 2M | | | | | | | | | | 14 | NESTED LOOPS ANTI | | 1 | 19887 | | | | | | | | | | | | | | 15 | VIEW | | 3 | 19884 | | | | | | | | | | | | | | 16 | UNION-ALL | | | | | | | | | | | | | | | | | 17 | FILTER | | | | | | | | | | | | | | | | | 18 | HASH JOIN OUTER | | 2 | 16676 | | | | | | | | | | | | | | 19 | TABLE ACCESS STORAGE FULL | CS | 948K | 2683 | | | | | | | | | | | | | | 20 | TABLE ACCESS STORAGE FULL | COX | 2M | 3213 | | | | | | | | | | | | | | 21 | NESTED LOOPS ANTI | | 1 | 3208 | | | | | | | | | | | | | | 22 | TABLE ACCESS STORAGE FULL | COX | 2 | 3206 | | | | | | | | | | | | | | 23 | INDEX UNIQUE SCAN | CS_PK | 948K | 1 | | | | | | | | | | | | | | 24 | INDEX UNIQUE SCAN | BOS_PK | 1M | 1 | | | | | | | | | | | | | ========================================================================================================================================================================================================================