|
---------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
----------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 3 | 178 | 20 (25)| 00:00:01 |
| 1 | SORT ORDER BY | | 3 | 178 | 19 (22)| 00:00:01 |
| 2 | UNION-ALL | | | | | |
|* 3 | HASH JOIN OUTER | | 2 | 120 | 16 (19)| 00:00:01 |
| 4 | VIEW | | 2 | 60 | 5 (20)| 00:00:01 |
| 5 | HASH GROUP BY | | 2 | 68 | 5 (20)| 00:00:01 |
| 6 | VIEW | DBA_DATA_FILES | 2 | 68 | 4 (0)| 00:00:01 |
| 7 | UNION-ALL | | | | | |
| 8 | NESTED LOOPS | | 1 | 356 | 2 (0)| 00:00:01 |
| 9 | NESTED LOOPS | | 1 | 341 | 1 (0)| 00:00:01 |
| 10 | NESTED LOOPS | | 1 | 328 | 1 (0)| 00:00:01 |
|* 11 | FIXED TABLE FULL | X$KCCFN | 1 | 310 | 0 (0)| 00:00:01 |
|* 12 | TABLE ACCESS BY INDEX ROWID| FILE$ | 1 | 18 | 1 (0)| 00:00:01 |
|* 13 | INDEX UNIQUE SCAN | I_FILE1 | 1 | | 0 (0)| 00:00:01 |
|* 14 | FIXED TABLE FIXED INDEX | X$KCCFE (ind:1) | 20 | 260 | 0 (0)| 00:00:01 |
| 15 | TABLE ACCESS CLUSTER | TS$ | 1 | 15 | 1 (0)| 00:00:01 |
|* 16 | INDEX UNIQUE SCAN | I_TS# | 1 | | 0 (0)| 00:00:01 |
| 17 | NESTED LOOPS | | 1 | 399 | 2 (0)| 00:00:01 |
| 18 | NESTED LOOPS | | 1 | 386 | 2 (0)| 00:00:01 |
| 19 | NESTED LOOPS | | 1 | 377 | 1 (0)| 00:00:01 |
| 20 | NESTED LOOPS | | 1 | 362 | 0 (0)| 00:00:01 |
|* 21 | FIXED TABLE FULL | X$KCCFN | 1 | 310 | 0 (0)| 00:00:01 |
|* 22 | FIXED TABLE FIXED INDEX | X$KTFBHC (ind:1) | 1 | 52 | 0 (0)| 00:00:01 |
| 23 | TABLE ACCESS CLUSTER | TS$ | 1 | 15 | 1 (0)| 00:00:01 |
|* 24 | INDEX UNIQUE SCAN | I_TS# | 1 | | 0 (0)| 00:00:01 |
|* 25 | TABLE ACCESS BY INDEX ROWID | FILE$ | 1 | 9 | 1 (0)| 00:00:01 |
|* 26 | INDEX UNIQUE SCAN | I_FILE1 | 1 | | 0 (0)| 00:00:01 |
|* 27 | FIXED TABLE FIXED INDEX | X$KCCFE (ind:1) | 20 | 260 | 0 (0)| 00:00:01 |
| 28 | VIEW | | 5 | 150 | 11 (19)| 00:00:01 |
| 29 | HASH GROUP BY | | 5 | 105 | 11 (19)| 00:00:01 |
| 30 | VIEW | DBA_FREE_SPACE | 79 | 1659 | 10 (10)| 00:00:01 |
| 31 | UNION-ALL | | | | | |
| 32 | NESTED LOOPS | | 1 | 64 | 1 (0)| 00:00:01 |
| 33 | NESTED LOOPS | | 1 | 45 | 1 (0)| 00:00:01 |
| 34 | INDEX FULL SCAN | I_FILE2 | 5 | 30 | 1 (0)| 00:00:01 |
|* 35 | TABLE ACCESS CLUSTER | FET$ | 1 | 39 | 0 (0)| 00:00:01 |
|* 36 | INDEX UNIQUE SCAN | I_TS# | 1 | | 0 (0)| 00:00:01 |
|* 37 | TABLE ACCESS CLUSTER | TS$ | 1 | 19 | 0 (0)| 00:00:01 |
|* 38 | INDEX UNIQUE SCAN | I_TS# | 1 | | 0 (0)| 00:00:01 |
| 39 | NESTED LOOPS | | 76 | 5320 | 4 (0)| 00:00:01 |
| 40 | NESTED LOOPS | | 76 | 4864 | 4 (0)| 00:00:01 |
|* 41 | TABLE ACCESS FULL | TS$ | 5 | 125 | 4 (0)| 00:00:01 |
|* 42 | FIXED TABLE FIXED INDEX | X$KTFBFE (ind:1) | 17 | 663 | 0 (0)| 00:00:01 |
|* 43 | INDEX UNIQUE SCAN | I_FILE2 | 1 | 6 | 0 (0)| 00:00:01 |
| 44 | NESTED LOOPS | | 1 | 135 | 2 (50)| 00:00:01 |
| 45 | NESTED LOOPS | | 1 | 70 | 1 (0)| 00:00:01 |
| 46 | NESTED LOOPS | | 1 | 45 | 1 (0)| 00:00:01 |
| 47 | INDEX FULL SCAN | I_FILE2 | 5 | 30 | 1 (0)| 00:00:01 |
| 48 | TABLE ACCESS BY INDEX ROWID| RECYCLEBIN$ | 1 | 39 | 0 (0)| 00:00:01 |
|* 49 | INDEX RANGE SCAN | RECYCLEBIN$_TS | 1 | | 0 (0)| 00:00:01 |
|* 50 | TABLE ACCESS CLUSTER | TS$ | 1 | 25 | 0 (0)| 00:00:01 |
|* 51 | INDEX UNIQUE SCAN | I_TS# | 1 | | 0 (0)| 00:00:01 |
|* 52 | FIXED TABLE FIXED INDEX | X$KTFBUE (ind:1) | 1 | 65 | 1 (100)| 00:00:01 |
| 53 | NESTED LOOPS | | 1 | 116 | 3 (0)| 00:00:01 |
| 54 | NESTED LOOPS | | 1 | 97 | 3 (0)| 00:00:01 |
| 55 | MERGE JOIN CARTESIAN | | 1 | 45 | 3 (0)| 00:00:01 |
| 56 | TABLE ACCESS FULL | RECYCLEBIN$ | 1 | 39 | 2 (0)| 00:00:01 |
| 57 | BUFFER SORT | | 5 | 30 | 1 (0)| 00:00:01 |
| 58 | INDEX FULL SCAN | I_FILE2 | 5 | 30 | 1 (0)| 00:00:01 |
| 59 | TABLE ACCESS CLUSTER | UET$ | 1 | 52 | 0 (0)| 00:00:01 |
|* 60 | INDEX UNIQUE SCAN | I_FILE#_BLOCK# | 1 | | 0 (0)| 00:00:01 |
|* 61 | TABLE ACCESS CLUSTER | TS$ | 1 | 19 | 0 (0)| 00:00:01 |
|* 62 | INDEX UNIQUE SCAN | I_TS# | 1 | | 0 |