recyclebin$里表太多引发的问题(五)
71 | 4686 | 5 (0)| 00:00:01 |
|* 39 | TABLE ACCESS FULL | TS$ | 10 | 270 | 5 (0)| 00:00:01 |
|* 40 | FIXED TABLE FIXED INDEX | X$KTFBFE (ind:1) | 7 | 273 | 0 (0)| 00:00:01 |
|* 41 | INDEX UNIQUE SCAN | I_FILE2 | 1 | 7 | 0 (0)| 00:00:01 |
| 42 | NESTED LOOPS | | 1 | 138 | 15 (60)| 00:00:01 |
| 43 | NESTED LOOPS | | 1 | 131 | 15 (60)| 00:00:01 |
| 44 | MERGE JOIN | | 1 | 66 | 7 (15)| 00:00:01 |
| 45 | TABLE ACCESS BY INDEX ROWID| RECYCLEBIN$ | 1 | 39 | 1 (0)| 00:00:01 |
| 46 | INDEX FULL SCAN | RECYCLEBIN$_TS | 1 | | 1 (0)| 00:00:01 |
|* 47 | SORT JOIN | | 10 | 270 | 6 (17)| 00:00:01 |
|* 48 | TABLE ACCESS FULL | TS$ | 10 | 270 | 5 (0)| 00:00:01 |
|* 49 | FIXED TABLE FIXED INDEX | X$KTFBUE (ind:1) | 3277 | 208K| 8 (100)| 00:00:01 |
|* 50 | INDEX UNIQUE SCAN | I_FILE2 | 1 | 7 | 0 (0)| 00:00:01 |
| 51 | NESTED LOOPS | | 1 | 119 | 16 (0)| 00:00:01 |
| 52 | NESTED LOOPS | | 1 | 98 | 15 (0)| 00:00:01 |
| 53 | NESTED LOOPS | | 1 | 59 | 14 (0)| 00:00:01 |
| 54 | TABLE ACCESS FULL | UET$ | 1 | 52 | 14 (0)| 00:00:01 |
|* 55 | INDEX UNIQUE SCAN | I_FILE2 | 1 | 7 | 0 (0)| 00:00:01 |
|* 56 | TABLE ACCESS BY INDEX ROWID | RECYCLEBIN$ | 1 | 39 | 1 (0)| 00:00:01 |
|* 57 | INDEX RANGE SCAN | RECYCLEBIN$_TS | 1 | | 1 (0)| 00:00:01 |
|* 58 | TABLE ACCESS CLUSTER | TS$ | 1 | 21 | 1 (0)| 00:00:01 |
|* 59 | INDEX UNIQUE SCAN | I_TS# | 1 | | 0 (0)| 00:00:01 |
| 60 | VIEW | | 2 | 60 | 5 (20)| 00:00:01 |
| 61 | HASH GROUP BY | | 2 | 294 | 5 (20)| 00:00:01 |
| 62 | VIEW | DBA_DATA_FILES | 2 | 294 | 4 (0)| 00:00:01 |
| 63 | UNION-ALL | | | | | |
| 64 | NESTED LOOPS | | 1 | 222 | 2 (0)| 00:00:01 |
| 65 | NESTED LOOPS | | 1 | 209 | 1 (0)| 00:00:01 |
| 66 | NESTED LOOPS | | 1 | 196 | 1 (0)| 00:00:01 |
|* 67 | FIXED TABLE FULL | X$KCCFN | 1 | 182 | 0 (0)| 00:00:01 |
|* 68 | TABLE ACCESS BY INDEX ROWID | FILE$ | 1 | 14 | 1 (0)| 00:00:01 |
|* 69 | INDEX UNIQUE SCAN | I_FILE1 | 1 | | 0 (0)| 00:00:01 |
|* 70 | FIXED TABLE FIXED INDEX | X$KCCFE (ind:1) | 1 | 13 | 0 (0)| 00:00:01 |
| 71 | TABLE ACCESS CLUSTER | TS$ | 1 | 13 | 1 (0)| 00:00:01 |
|* 72 | INDEX UNIQUE SCAN | I_TS# | 1 | | 0 (0)| 00:00:01 |
| 73 | NESTED LOOPS | | 1 | 245 | 2 (0)| 00:00:01 |
| 74 | NESTED LOOPS | | 1 | 232 | 1 (0)| 00:00:01 |
| 75 | NESTED LOOPS | | 1 | 219 | 1 (0)| 00:00:01 |
| 76 | NESTED LOOPS | | 1 | 208 | 0 (0)| 00:00:01 |
|* 77 | FIXED TABLE FULL | X$KCCFN | 1 | 182 | 0 (0)| 00:00:01 |
|* 78 | FIXED TABLE FIXED INDEX | X$KTFBHC (ind:1) | 1 | 26 | 0 (0)| 00:00:01 |
|* 79 | TABLE ACCESS BY INDEX ROWID | FILE$