recyclebin$里表太多引发的问题(二)
NDEX ROWID| FILE$ | 1 | 20 | 1 (0)| 00:00:01 |
|* 37 | INDEX UNIQUE SCAN | I_FILE1 | 1 | | 0 (0)| 00:00:01 |
|* 38 | FIXED TABLE FIXED INDEX | X$KCCFE (ind:1) | 1 | 13 | 0 (0)| 00:00:01 |
| 39 | TABLE ACCESS CLUSTER | TS$ | 1 | 17 | 1 (0)| 00:00:01 |
|* 40 | INDEX UNIQUE SCAN | I_TS# | 1 | | 0 (0)| 00:00:01 |
| 41 | NESTED LOOPS | | 1 | 275 | 2 (0)| 00:00:01 |
| 42 | NESTED LOOPS | | 1 | 258 | 1 (0)| 00:00:01 |
| 43 | NESTED LOOPS | | 1 | 245 | 1 (0)| 00:00:01 |
| 44 | NESTED LOOPS | | 1 | 234 | 0 (0)| 00:00:01 |
|* 45 | FIXED TABLE FULL | X$KCCFN | 1 | 182 | 0 (0)| 00:00:01 |
|* 46 | FIXED TABLE FIXED INDEX | X$KTFBHC (ind:1) | 1 | 52 | 0 (0)| 00:00:01 |
|* 47 | TABLE ACCESS BY INDEX ROWID| FILE$ | 1 | 11 | 1 (0)| 00:00:01 |
|* 48 | INDEX UNIQUE SCAN | I_FILE1 | 1 | | 0 (0)| 00:00:01 |
|* 49 | FIXED TABLE FIXED INDEX | X$KCCFE (ind:1) | 1 | 13 | 0 (0)| 00:00:01 |
| 50 | TABLE ACCESS CLUSTER | TS$ | 1 | 17 | 1 (0)| 00:00:01 |
|* 51 | INDEX UNIQUE SCAN | I_TS# | 1 | | 0 (0)| 00:00:01 |
| 52 | VIEW | | 15338 | 449K| 386K(100)| 01:17:24 |
| 53 | HASH GROUP BY | | 15338 | 449K| 386K(100)| 01:17:24 |
| 54 | VIEW | DBA_FREE_SPACE | 15338 | 449K| 386K(100)| 01:17:24 |
| 55 | UNION-ALL | | | | | |
| 56 | NESTED LOOPS | | 1 | 67 | 4 (0)| 00:00:01 |
| 57 | NESTED LOOPS | | 1 | 46 | 3 (0)| 00:00:01 |
| 58 | TABLE ACCESS FULL | FET$ | 1 | 39 | 3 (0)| 00:00:01 |
|* 59 | INDEX UNIQUE SCAN | I_FILE2 | 1 | 7 | 0 (0)| 00:00:01 |
|* 60 | TABLE ACCESS CLUSTER | TS$ | 1 | 21 | 1 (0)| 00:00:01 |
| 61 | NESTED LOOPS | | 71 | 5183 | 5 (0)| 00:00:01 |
| 62 | NESTED LOOPS | | 71 | 4686 | 5 (0)| 00:00:01 |
|* 63 | TABLE ACCESS FULL | TS$ | 10 | 270 | 5 (0)| 00:00:01 |
|* 64 | FIXED TABLE FIXED INDEX | X$KTFBFE (ind:1) | 7 | 273 | 0 (0)| 00:00:01 |
|* 65 | INDEX UNIQUE SCAN | I_FILE2 | 1 | 7 | 0 (0)| 00:00:01 |
| 66 | NESTED LOOPS | | 15265 | 1654K| 386K(100)| 01:17:24 |
| 67 | NESTED LOOPS | | 95349 | 9683K| 386K(100)| 01:17:24 |
|* 68 | HASH JOIN | | 49103 | 1870K| 159 (2)| 00:00:02 |
| 69 | TABLE ACCESS FULL | RECYCLEBIN$ | 51498 | 603K| 153 (1)| 00:00:02 |
|* 70 | TABLE ACCESS FULL | TS$ | 10 | 270 | 5 (0)| 00:00:01 |
|* 71 | FIXED TABLE FIXED INDEX | X$KTFBUE (ind:1) | 2 | 130 | 8 (100)| 00:00:01 |
|* 72 | INDEX UNIQUE SCAN | I_FILE2 | 1 | 7 | 0 (0)| 00:00:01 |
| 73 | NESTED LOOPS | | 1 | 92 | 16 (0)| 00:00:01 |
| 74 | NESTED LOOPS | | 1 | 71 | 15 (0)| 00:00:01 |
| 75 | NESTED LOOPS | | 1 | 59 | 14 (0)| 00:00:01 |
| 76 | TABLE ACCESS FULL | UET$ | 1 | 52 | 14 (0)| 00:00:01 |