Global Information ------------------------------ Status : DONE (ALL ROWS) Instance ID : 4 SQL Execution ID : 68591070 Execution Started : 04/08/2021 10:16:22 First Refresh Time : 04/08/2021 10:20:20 Last Refresh Time : 04/08/2021 10:20:24 Duration : 242s Program : JDBC Thin Client Fetch Calls : 1 Global Stats ============================================================================================================== | Elapsed | Cpu | IO | Application | Cluster | Other | Fetch | Buffer | Read | Read | Cell | | Time(s) | Time(s) | Waits(s) | Waits(s) | Waits(s) | Waits(s) | Calls | Gets | Reqs | Bytes | Offload | ============================================================================================================== | 242 | 1.00 | 5.84 | 0.01 | 0.03 | 235 | 1 | 251K | 1913 | 2GB | 93.03% | ============================================================================================================== SQL Plan Monitoring Details (Plan Hash Value=1226569545) =================================================================================================================================================================================================================================== | Id | Operation | Name | Rows | Cost | Time | Start | Execs | Rows | Read | Read | Cell | Mem | Activity | Activity Detail | | | | | (Estim) | | Active(s) | Active | | (Actual) | Reqs | Bytes | Offload | (Max) | (%) | (# samples) | =================================================================================================================================================================================================================================== | 0 | SELECT STATEMENT | | | | 5 | +238 | 1 | 3 | | | | | | | | 1 | SORT ORDER BY | | 2 | 901K | 5 | +238 | 1 | 3 | | | | 2048 | | | | 2 | UNION-ALL | | | | 1 | +238 | 1 | 3 | | | | | | | | 3 | HASH UNIQUE | | 1 | 8731 | 1 | +238 | 1 | 3 | | | | 768K | | | | 4 | NESTED LOOPS | | 1 | 8730 | 1 | +238 | 1 | 30 | | | | | | | | 5 | NESTED LOOPS | | 1 | 8730 | 1 | +238 | 1 | 30 | | | | | | | | 6 | NESTED LOOPS | | 1 | 8729 | 1 | +238 | 1 | 30 | | | | | | | | 7 | NESTED LOOPS | | 1 | 7262 | 1 | +238 | 1 | 10 | | | | | | | | 8 | NESTED LOOPS | | 1 | 5649 | 1 | +238 | 1 | 10 | | | | | | | | 9 | PARTITION RANGE ALL | | 3 | 803 | 1 | +238 | 1 | 1 | | | | | | | | 10 | TABLE ACCESS BY LOCAL INDEX ROWID | TFE | 3 | 803 | 1 | +238 | 267 | 1 | | | | | | | | 11 | INDEX RANGE SCAN | TFE_X9 | 3 | 802 | 1 | +238 | 211 | 1 | | | | | | | | 12 | PARTITION RANGE ALL | | 1 | 1615 | 1 | +238 | 1 | 10 | | | | | | | | 13 | TABLE ACCESS BY LOCAL INDEX ROWID | TSE | 1 | 1615 | 1 | +238 | 538 | 10 | | | | | | | | 14 | INDEX RANGE SCAN | TSE_X2 | 3 | 1614 | 1 | +238 | 483 | 10 | | | | | | | | 15 | PARTITION RANGE ALL | | 1 | 1612 | 1 | +238 | 10 | 10 | | | | | | | | 16 | TABLE ACCESS BY LOCAL INDEX ROWID | TSFEF | 1 | 1612 | 1 | +238 | 5370 | 10 | | | | | | | | 17 | INDEX RANGE SCAN | TSFEF_X2 | 1 | 1611 | 238 | +1 | 4830 | 10 | | | | | 0.41 | cell single block physical read (1) | | 18 | PARTITION RANGE ALL | | 3 | 1467 | 1 | +238 | 10 | 30 | | | | | | | | 19 | TABLE ACCESS BY LOCAL INDEX ROWID | TSFTH | 3 | 1467 | 1 | +238 | 5370 | 30 | | | | | | | | 20 | INDEX RANGE SCAN | TSFTH_X2 | 481 | 1074 | 237 | +2 | 4880 | 30 | | | | | 0.41 | cell single block physical read (1) | | 21 | INDEX RANGE SCAN | TMCT_X1 | 1 | | 1 | +238 | 30 | 30 | | | | | | | | 22 | TABLE ACCESS BY INDEX ROWID | TMCT | 1 | 1 | 1 | +238 | 30 | 30 | | | | | | | | 23 | HASH UNIQUE | | 1 | 892K | | | 1 | | | | | | | | | 24 | NESTED LOOPS | | 1 | 892K | | | 1 | | | | | | | | | 25 | NESTED LOOPS | | 1 | 892K | | | 1 | | | | | | | | | 26 | NESTED LOOPS | | 1 | 892K | | | 1 | | | | | | | | | 27 | NESTED LOOPS | | 1 | 891K | | | 1 | | | | | | | | | 28 | NESTED LOOPS | | 1 | 889K | | | 1 | | | | | | | | | 29 | HASH JOIN | | 523 | 44338 | 5 | +238 | 1 | 0 | | | | 293M | | | | 30 | TABLE ACCESS STORAGE FULL | TSFS | 3M | 37797 | 240 | +3 | 1 | 3M | 1130 | 1GB | 92.52% | 7M | 99.17 | reliable message (235) | | | | | | | | | | | | | | | | cell smart table scan (4) | | 31 | PARTITION RANGE ALL | | 3 | 803 | 1 | +242 | 1 | 1 | | | | | | | | 32 | TABLE ACCESS BY LOCAL INDEX ROWID | TFE | 3 | 803 | 1 | +242 | 267 | 1 | | | | | | | | 33 | INDEX RANGE SCAN | TFE_X9 | 3 | 802 | 1 | +242 | 211 | 1 | | | | | | | | 34 | PARTITION RANGE ALL | | 1 | 1615 | | | | | | | | | | | | 35 | TABLE ACCESS BY LOCAL INDEX ROWID | TSE | 1 | 1615 | | | | | | | | | | | | 36 | INDEX RANGE SCAN | TSE_X2 | 3 | 1614 | | | | | | | | | | | | 37 | PARTITION RANGE ALL | | 1 | 1612 | | | | | | | | | | | | 38 | TABLE ACCESS BY LOCAL INDEX ROWID | TSFEF | 1 | 1612 | | | | | | | | | | | | 39 | INDEX RANGE SCAN | TSFEF_X2 | 1 | 1611 | | | | | | | | | | | | 40 | PARTITION RANGE ALL | | 3 | 1467 | | | | | | | | | | | | 41 | TABLE ACCESS BY LOCAL INDEX ROWID | TSFTH | 3 | 1467 | | | | | | | | | | | | 42 | INDEX RANGE SCAN | TSFTH_X2 | 481 | 1074 | | | | | | | | | | | | 43 | INDEX RANGE SCAN | TMCT_X1 | 1 | | | | | | | | | | | | | 44 | TABLE ACCESS BY INDEX ROWID | TMCT | 1 | 1 | | | | | | | | | | | ===================================================================================================================================================================================================================================