当前位置：首页 -> AI编程基础 -> 数据库编程

recyclebin$里表太多引发的问题(四)

2014-11-24 16:24:36 · 作者: · 浏览: 2
标签: recyclebin 引发 问题
------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
----------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 90 | 53 (27)| 00:00:01 |
| 1 | SORT ORDER BY | | 1 | 90 | 53 (27)| 00:00:01 |
|* 2 | HASH JOIN | | 1 | 90 | 52 (25)| 00:00:01 |
|* 3 | HASH JOIN | | 1 | 60 | 46 (24)| 00:00:01 |
| 4 | VIEW | | 2 | 60 | 5 (20)| 00:00:01 |
| 5 | HASH GROUP BY | | 2 | 60 | 5 (20)| 00:00:01 |
| 6 | VIEW | DBA_DATA_FILES | 2 | 60 | 4 (0)| 00:00:01 |
| 7 | UNION-ALL | | | | | |
| 8 | NESTED LOOPS | | 1 | 232 | 2 (0)| 00:00:01 |
| 9 | NESTED LOOPS | | 1 | 215 | 1 (0)| 00:00:01 |
| 10 | NESTED LOOPS | | 1 | 202 | 1 (0)| 00:00:01 |
|* 11 | FIXED TABLE FULL | X$KCCFN | 1 | 182 | 0 (0)| 00:00:01 |
|* 12 | TABLE ACCESS BY INDEX ROWID| FILE$ | 1 | 20 | 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) | 1 | 13 | 0 (0)| 00:00:01 |
| 15 | TABLE ACCESS CLUSTER | TS$ | 1 | 17 | 1 (0)| 00:00:01 |
|* 16 | INDEX UNIQUE SCAN | I_TS# | 1 | | 0 (0)| 00:00:01 |
| 17 | NESTED LOOPS | | 1 | 275 | 2 (0)| 00:00:01 |
| 18 | NESTED LOOPS | | 1 | 258 | 1 (0)| 00:00:01 |
| 19 | NESTED LOOPS | | 1 | 245 | 1 (0)| 00:00:01 |
| 20 | NESTED LOOPS | | 1 | 234 | 0 (0)| 00:00:01 |
|* 21 | FIXED TABLE FULL | X$KCCFN | 1 | 182 | 0 (0)| 00:00:01 |
|* 22 | FIXED TABLE FIXED INDEX | X$KTFBHC (ind:1) | 1 | 52 | 0 (0)| 00:00:01 |
|* 23 | TABLE ACCESS BY INDEX ROWID| FILE$ | 1 | 11 | 1 (0)| 00:00:01 |
|* 24 | INDEX UNIQUE SCAN | I_FILE1 | 1 | | 0 (0)| 00:00:01 |
|* 25 | FIXED TABLE FIXED INDEX | X$KCCFE (ind:1) | 1 | 13 | 0 (0)| 00:00:01 |
| 26 | TABLE ACCESS CLUSTER | TS$ | 1 | 17 | 1 (0)| 00:00:01 |
|* 27 | INDEX UNIQUE SCAN | I_TS# | 1 | | 0 (0)| 00:00:01 |
| 28 | VIEW | | 74 | 2220 | 41 (25)| 00:00:01 |
| 29 | HASH GROUP BY | | 74 | 2220 | 41 (25)| 00:00:01 |
| 30 | VIEW | DBA_FREE_SPACE | 74 | 2220 | 40 (23)| 00:00:01 |
| 31 | UNION-ALL | | | | | |
| 32 | NESTED LOOPS | | 1 | 67 | 4 (0)| 00:00:01 |
| 33 | NESTED LOOPS | | 1 | 46 | 3 (0)| 00:00:01 |
| 34 | TABLE ACCESS FULL | FET$ | 1 | 39 | 3 (0)| 00:00:01 |
|* 35 | INDEX UNIQUE SCAN | I_FILE2 | 1 | 7 | 0 (0)| 00:00:01 |
|* 36 | TABLE ACCESS CLUSTER | TS$ | 1 | 21 | 1 (0)| 00:00:01 |
| 37 | NESTED LOOPS | | 71 | 5183 | 5 (0)| 00:00:01 |
| 38 | NESTED LOOPS | |