optimizer_features_enable string 10.2.0.5
optimizer_index_caching integer 0
optimizer_index_cost_adj integer 100
optimizer_mode string ALL_ROWS
11:36:41 SQL> SELECT /*+ GATHER_PLAN_STATISTICS */
upper(f.tablespace_name) col_a,
d.tot_grootte_mb col_b,
d.tot_grootte_mb - f.total_bytes col_c,
to_char(round((d.tot_grootte_mb - f.total_bytes) / d.tot_grootte_mb * 100, 2), '990.99') || '%' col_d,
f.total_bytes col_e,
(SELECT free_space_mb + free_allocate_mb
FROM dba_tablespace_free a
WHERE a.tablespace_name = f.tablespace_name) col_f,
f.max_bytes col_g
from (SELECT tablespace_name,
round(SUM(bytes) / (1024 * 1024), 2) total_bytes,
round(MAX(bytes) / (1024 * 1024), 2) max_bytes
from dba_free_space
group BY tablespace_name) f,
(SELECT dd.tablespace_name,
round(SUM(dd.bytes) / (1024 * 1024), 2) tot_grootte_mb
from dba_data_files dd
group BY dd.tablespace_name) d
where d.tablespace_name = f.tablespace_name;
COL_A COL_B COL_C COL_D COL_E COL_F COL_G
------------------------------ ---------- ---------- -------- ---------- ---------- ----------
UNDOTBS1 11125 136.25 1.22% 10988.75 32635.7344 3968
SYSAUX 4096 763.75 18.65% 3332.25 32004.2344 3178
TS_IDX 20480 861.12 4.20% 19618.88 19618.88 3968
USERS 5 .44 8.80% 4.56 32767.5444 4.56
TS_WORK 143360 114759.25 80.05% 28600.75 28584.75 2164
SYSTEM 4096 611.25 14.92% 3484.75 3484.75 3356
TS_PART 61440 49689.75 80.88% 11750.25 11749.25 837
UNDOTBS2 13575 547.19 4.03% 13027.81 32220.7944 3968
TS_COMM_INCOM 122880 8467.56 6.89% 114412.44 114412.44 3968
9 rows selected.
Elapsed: 00:00:41.73
11:39:16 SQL> SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY_CURSOR(NULL,NULL,'ALLSTATS LAST'));
PLAN_TABLE_OUTPUT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL_ID 8kdacwcnaqc3g, child number 0
-------------------------------------
SELECT /*+ GATHER_PLAN_STATISTICS */ upper(f.tablespace_name) col_a, d.tot_grootte_mb col_b, d.tot_grootte_mb -
f.total_bytes col_c, to_char(round((d.tot_grootte_mb - f.total_bytes) / d.tot_grootte_mb * 100, 2), '990.99') || '%' col_d,
f.total_bytes col_e, (SELECT free_space_mb + free_allocate_mb FROM dba_tablespace_free a WHERE a.tablespace_name =
f.tablespace_name) col_f, f.max_bytes col_g from (SELECT tablespace_name, round(SUM(bytes) / (1024 * 1024), 2)
total_bytes, round(MAX(bytes) / (1024 * 1024), 2) max_bytes from dba_free_space group BY tablespace_name) f,
(SELECT dd.tablespace_name, round(SUM(dd.bytes) / (1024 * 1024), 2) tot_grootte_mb from dba_data_files dd
group BY dd.tablespace_name) d where d.tablespace_name = f.tablespace_name
Plan hash value: 3060313182
--------------------------------------------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Starts | E-Rows | A-Rows | A-Time | Buffers | Reads | OMem | 1Mem | Used-Mem |
--------------------------------------------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | | 9 |00:00:31.24 | 22597 | 3613 | | | |
| 1 | MERGE JOIN | | 9 | 2 | 9 |00:00:09.46 | 16105 | 3613 | | | |
| 2 | VIEW | | 9 | 100 | 9 |00:00:09.42 | 15670 | 3613 | | | |
| 3 | SORT GROUP BY | | 9 | 8424 | 9 |00:00:09.42 | 15670 | 3613 | 2048 | 2048 | 2048 (0)|
| 4 | VIEW | DBA_FREE_SPACE | 9 | 8424 | 6357 |00:00:01.56 | 15670 | 3613 | | | |
| 5 | UNION-ALL | | 9 | | 6357 |00:00:01.56 | 15670 | 3613 | | | |
| 6 | NESTED LOOPS | | 9 | 1 | 0 |00:00:00.01 | 18 | 0 | | | |
| 7 | NESTED LOOPS | | 9 | 1 | 0 |00:00:00.01 | 18 | 0 | | | |
|* 8 | TABLE ACCESS BY INDEX ROWID | TS$ | 9 | 1 | 0 |00:00:00.01 | 18 | 0 | | | |
|* 9 | INDEX UNIQUE SCAN | I_TS1 | 9 | 1 | 9 |00:00:00.01 | 9 | 0 | | | |
|* 10 | TABLE ACCESS CLUSTER | FET$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 11 | INDEX UNIQUE SCAN | I_FILE2 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
| 12 | NESTED LOOPS | | 9 | 8 | 1462 |00:00:00.04 | 312 | 0 | | | |
| 13 | NESTED LOOPS | | 9 | 8 | 1462 |00:00:00.03 | 302 | 0 | | | |
|* 14 | TABLE ACCESS BY INDEX ROWID | TS$ | 9 | 1 | 9 |00:00:00.01 | 18 | 0 | | | |
|* 15 | INDEX UNIQUE SCAN | I_TS1 | 9 | 1 | 9 |00:00:00.01 | 9 | 0 | | | |
|* 16 | FIXED TABLE FIXED INDEX | X$KTFBFE (ind:1) | 9 | 8 | 1462 |00:00:00.03 | 284 | 0 | | | |
|* 17 | INDEX UNIQUE SCAN | I_FILE2 | 1462 | 1 | 1462 |00:00:00.01 | 10 | 0 | | | |
| 18 | NESTED LOOPS | | 9 | 8414 | 4895 |00:00:01.67 | 15322 | 3613 | | | |
| 19 | NESTED LOOPS | | 9 | 33241 | 4895 |00:00:01.65 | 15318 | 3613 | | | |
|* 20 | HASH JOIN | | 9 | 1200 | 3613 |00:00:00.02 | 468 | 0 | 1155K| 1155K| 906K (0)|
| 21 | TABLE ACCESS FULL | RECYCLEBIN$ | 9 | 3610 | 32607 |00:00:00.01 | 450 | 0 | | | |
|* 22 | TABLE ACCESS BY INDEX ROWID | TS$ | 9 | 1 | 9 |00:00:00.01 | 18 | 0 | | | |
|* 23 | INDEX UNIQUE SCAN | I_TS1 | 9 | 1 | 9 |00:00:00.01 | 9 | 0 | | | |
|* 24 | FIXED TABLE FIXED INDEX | X$KTFBUE (ind:1) | 3613 | 28 | 4895 |00:00:09.32 | 14850 | 3613 | | | |
|* 25 | INDEX UNIQUE SCAN | I_FILE2 | 4895 | 1 | 4895 |00:00:00.02 | 4 | 0 | | | |
| 26 | NESTED LOOPS | | 9 | 1 | 0 |00:00:00.01 | 18 | 0 | | | |
| 27 | NESTED LOOPS | | 9 | 1 | 0 |00:00:00.01 | 18 | 0 | | | |
| 28 | NESTED LOOPS | | 9 | 3610 | 0 |00:00:00.01 | 18 | 0 | | | |
|* 29 | TABLE ACCESS BY INDEX ROWID | TS$ | 9 | 1 | 0 |00:00:00.01 | 18 | 0 | | | |
|* 30 | INDEX UNIQUE SCAN | I_TS1 | 9 | 1 | 9 |00:00:00.01 | 9 | 0 | | | |
| 31 | TABLE ACCESS FULL | RECYCLEBIN$ | 0 | 3610 | 0 |00:00:00.01 | 0 | 0 | | | |
| 32 | TABLE ACCESS CLUSTER | UET$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 33 | INDEX UNIQUE SCAN | I_FILE#_BLOCK# | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 34 | INDEX UNIQUE SCAN | I_FILE2 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 35 | SORT JOIN | | 9 | 2 | 9 |00:00:00.04 | 435 | 0 | 2048 | 2048 | 2048 (0)|
| 36 | VIEW | | 9 | 2 | 9 |00:00:00.04 | 435 | 0 | | | |
| 37 | SORT GROUP BY | | 9 | 2 | 9 |00:00:00.04 | 435 | 0 | 2048 | 2048 | 2048 (0)|
| 38 | VIEW | DBA_DATA_FILES | 9 | 2 | 20 |00:00:00.04 | 435 | 0 | | | |
| 39 | UNION-ALL | | 9 | | 20 |00:00:00.04 | 435 | 0 | | | |
| 40 | NESTED LOOPS | | 9 | 1 | 0 |00:00:00.01 | 208 | 0 | | | |
| 41 | NESTED LOOPS | | 9 | 1 | 0 |00:00:00.01 | 208 | 0 | | | |
| 42 | NESTED LOOPS | | 9 | 1 | 180 |00:00:00.01 | 18 | 0 | | | |
| 43 | TABLE ACCESS BY INDEX ROWID | TS$ | 9 | 1 | 9 |00:00:00.01 | 18 | 0 | | | |
|* 44 | INDEX UNIQUE SCAN | I_TS1 | 9 | 1 | 9 |00:00:00.01 | 9 | 0 | | | |
|* 45 | FIXED TABLE FULL | X$KCCFN | 9 | 1 | 180 |00:00:00.01 | 0 | 0 | | | |
|* 46 | TABLE ACCESS BY INDEX ROWID | FILE$ | 180 | 1 | 0 |00:00:00.01 | 190 | 0 | | | |
|* 47 | INDEX UNIQUE SCAN | I_FILE1 | 180 | 1 | 180 |00:00:00.01 | 10 | 0 | | | |
|* 48 | FIXED TABLE FIXED INDEX | X$KCCFE (ind:1) | 0 | 5 | 0 |00:00:00.01 | 0 | 0 | | | |
| 49 | NESTED LOOPS | | 9 | 1 | 20 |00:00:00.03 | 227 | 0 | | | |
| 50 | NESTED LOOPS | | 9 | 1 | 20 |00:00:00.01 | 227 | 0 | | | |
| 51 | NESTED LOOPS | | 9 | 1 | 20 |00:00:00.01 | 198 | 0 | | | |
| 52 | NESTED LOOPS | | 9 | 1 | 180 |00:00:00.01 | 18 | 0 | | | |
| 53 | TABLE ACCESS BY INDEX ROWID| TS$ | 9 | 1 | 9 |00:00:00.01 | 18 | 0 | | | |
|* 54 | INDEX UNIQUE SCAN | I_TS1 | 9 | 1 | 9 |00:00:00.01 | 9 | 0 | | | |
|* 55 | FIXED TABLE FULL | X$KCCFN | 9 | 1 | 180 |00:00:00.01 | 0 | 0 | | | |
|* 56 | FIXED TABLE FIXED INDEX | X$KTFBHC (ind:1) | 180 | 1 | 20 |00:00:00.01 | 180 | 0 | | | |
|* 57 | TABLE ACCESS BY INDEX ROWID | FILE$ | 20 | 1 | 20 |00:00:00.01 | 29 | 0 | | | |
|* 58 | INDEX UNIQUE SCAN | I_FILE1 | 20 | 1 | 20 |00:00:00.01 | 9 | 0 | | | |
|* 59 | FIXED TABLE FIXED INDEX | X$KCCFE (ind:1) | 20 | 5 | 20 |00:00:00.02 | 0 | 0 | | | |
|* 60 | HASH JOIN | | 1 | 497 | 9 |00:00:31.24 | 22597 | 3613 | 1133K| 1133K| 835K (0)|
| 61 | VIEW | | 1 | 2 | 9 |00:00:00.02 | 86 | 0 | | | |
| 62 | HASH GROUP BY | | 1 | 2 | 9 |00:00:00.02 | 86 | 0 | 885K| 885K| 855K (0)|
| 63 | VIEW | DBA_DATA_FILES | 1 | 2 | 20 |00:00:00.02 | 86 | 0 | | | |
| 64 | UNION-ALL | | 1 | | 20 |00:00:00.02 | 86 | 0 | | | |
| 65 | NESTED LOOPS | | 1 | 1 | 0 |00:00:00.01 | 22 | 0 | | | |
| 66 | NESTED LOOPS | | 1 | 1 | 0 |00:00:00.01 | 22 | 0 | | | |
| 67 | NESTED LOOPS | | 1 | 1 | 0 |00:00:00.01 | 22 | 0 | | | |
|* 68 | FIXED TABLE FULL | X$KCCFN | 1 | 1 | 20 |00:00:00.01 | 0 | 0 | | | |
|* 69 | TABLE ACCESS BY INDEX ROWID | FILE$ | 20 | 1 | 0 |00:00:00.01 | 22 | 0 | | | |
|* 70 | INDEX UNIQUE SCAN | I_FILE1 | 20 | 1 | 20 |00:00:00.01 | 2 | 0 | | | |
|* 71 | FIXED TABLE FIXED INDEX | X$KCCFE (ind:1) | 0 | 5 | 0 |00:00:00.01 | 0 | 0 | | | |
| 72 | TABLE ACCESS CLUSTER | TS$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 73 | INDEX UNIQUE SCAN | I_TS# | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
| 74 | NESTED LOOPS | | 1 | 1 | 20 |00:00:00.02 | 64 | 0 | | | |
| 75 | NESTED LOOPS | | 1 | 1 | 20 |00:00:00.02 | 42 | 0 | | | |
| 76 | NESTED LOOPS | | 1 | 1 | 20 |00:00:00.01 | 42 | 0 | | | |
| 77 | NESTED LOOPS | | 1 | 1 | 20 |00:00:00.01 | 20 | 0 | | | |
|* 78 | FIXED TABLE FULL | X$KCCFN | 1 | 1 | 20 |00:00:00.01 | 0 | 0 | | | |
|* 79 | FIXED TABLE FIXED INDEX | X$KTFBHC (ind:1) | 20 | 1 | 20 |00:00:00.01 | 20 | 0 | | | |
|* 80 | TABLE ACCESS BY INDEX ROWID | FILE$ | 20 | 1 | 20 |00:00:00.01 | 22 | 0 | | | |
|* 81 | INDEX UNIQUE SCAN | I_FILE1 | 20 | 1 | 20 |00:00:00.01 | 2 | 0 | | | |
|* 82 | FIXED TABLE FIXED INDEX | X$KCCFE (ind:1) | 20 | 5 | 20 |00:00:00.01 | 0 | 0 | | | |
| 83 | TABLE ACCESS CLUSTER | TS$ | 20 | 1 | 20 |00:00:00.01 | 22 | 0 | | | |
|* 84 | INDEX UNIQUE SCAN | I_TS# | 20 | 1 | 20 |00:00:00.01 | 2 | 0 | | | |
| 85 | VIEW | | 1 | 24863 | 9 |00:00:31.21 | 22511 | 3613 | | | |
| 86 | HASH GROUP BY | | 1 | 24863 | 9 |00:00:31.21 | 22511 | 3613 | 815K| 815K| 1743K (0)|
| 87 | VIEW | DBA_FREE_SPACE | 1 | 24863 | 6361 |00:00:20.28 | 22511 | 3613 | | | |
| 88 | UNION-ALL | | 1 | | 6361 |00:00:20.27 | 22511 | 3613 | | | |
| 89 | NESTED LOOPS | | 1 | 1 | 0 |00:00:00.01 | 15 | 0 | | | |
| 90 | NESTED LOOPS | | 1 | 1 | 0 |00:00:00.01 | 15 | 0 | | | |
| 91 | TABLE ACCESS FULL | FET$ | 1 | 1 | 0 |00:00:00.01 | 15 | 0 | | | |
|* 92 | INDEX UNIQUE SCAN | I_FILE2 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|* 93 | TABLE ACCESS CLUSTER | TS$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
| 94 | NESTED LOOPS | | 1 | 74 | 1466 |00:00:00.02 | 301 | 0 | | | |
| 95 | NESTED LOOPS | | 1 | 74 | 1466 |00:00:00.02 | 299 | 0 | | | |
|* 96 | TABLE ACCESS FULL | TS$ | 1 | 9 | 9 |00:00:00.01 | 15 | 0 | | | |
|* 97 | FIXED TABLE FIXED INDEX | X$KTFBFE (ind:1) | 9 | 8 | 1466 |00:00:00.03 | 284 | 0 | | | |
|* 98 | INDEX UNIQUE SCAN | I_FILE2 | 1466 | 1 | 1466 |00:00:00.01 | 2 | 0 | | | |
| 99 | NESTED LOOPS | | 1 | 24787 | 4895 |00:00:28.09 | 14917 | 3613 | | | |
| 100 | NESTED LOOPS | | 1 | 97928 | 4895 |00:00:28.07 | 14915 | 3613 | | | |
|*101 | HASH JOIN | | 1 | 3535 | 3613 |00:00:00.01 | 65 | 0 | 1155K| 1155K| 898K (0)|
| 102 | TABLE ACCESS FULL | RECYCLEBIN$ | 1 | 3610 | 3623 |00:00:00.01 | 50 | 0 | | | |
|*103 | TABLE ACCESS FULL | TS$ | 1 | 9 | 9 |00:00:00.01 | 15 | 0 | | | |
|*104 | FIXED TABLE FIXED INDEX | X$KTFBUE (ind:1) | 3613 | 28 | 4895 |00:00:31.11 | 14850 | 3613 | | | |
|*105 | INDEX UNIQUE SCAN | I_FILE2 | 4895 | 1 | 4895 |00:00:00.02 | 2 | 0 | | | |
| 106 | NESTED LOOPS | | 1 | 1 | 0 |00:00:00.02 | 7278 | 0 | | | |
| 107 | NESTED LOOPS | | 1 | 1 | 0 |00:00:00.02 | 7278 | 0 | | | |
| 108 | NESTED LOOPS | | 1 | 1 | 0 |00:00:00.02 | 7278 | 0 | | | |
| 109 | TABLE ACCESS FULL | RECYCLEBIN$ | 1 | 3610 | 3623 |00:00:00.01 | 50 | 0 | | | |
| 110 | TABLE ACCESS CLUSTER | UET$ | 3623 | 1 | 0 |00:00:00.02 | 7228 | 0 | | | |
|*111 | INDEX UNIQUE SCAN | I_FILE#_BLOCK# | 3623 | 1 | 3613 |00:00:00.01 | 3615 | 0 | | | |
|*112 | INDEX UNIQUE SCAN | I_FILE2 | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|*113 | TABLE ACCESS CLUSTER | TS$ | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
|*114 | INDEX UNIQUE SCAN | I_TS# | 0 | 1 | 0 |00:00:00.01 | 0 | 0 | | | |
--------------------------------------------------------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
8 - filter("TS"."BITMAPPED"=0)
9 - access("TS"."NAME"=:B1)
10 - filter("TS"."TS#"="F"."TS#")
11 - access("F"."TS#"="FI"."TS#" AND "F"."FILE#"="FI"."RELFILE#")
14 - filter(("TS"."CONTENTS$"=0 AND "TS"."BITMAPPED"<>0 AND INTERNAL_FUNCTION("TS"."ONLINE$")))
15 - access("TS"."NAME"=:B1)
16 - filter("TS"."TS#"="F"."KTFBFETSN")
17 - access("F"."KTFBFETSN"="FI"."TS#" AND "F"."KTFBFEFNO"="FI"."RELFILE#")
20 - access("TS"."TS#"="RB"."TS#")
22 - filter(("TS"."CONTENTS$"=0 AND "TS"."BITMAPPED"<>0 AND INTERNAL_FUNCTION("TS"."ONLINE$")))
23 - access("TS"."NAME"=:B1)
24 - filter(("U"."KTFBUESEGTSN"="RB"."TS#" AND "U"."KTFBUESEGFNO"="RB"."FILE#" AND "U"."KTFBUESEGBNO"="RB"."BLOCK#"))
25 - access("RB"."TS#"="FI"."TS#" AND "U"."KTFBUEFNO"="FI"."RELFILE#")
29 - filter("TS"."BITMAPPED"=0)
30 - access("TS"."NAME"=:B1)
33 - access("U"."TS#"="RB"."TS#" AND "U"."SEGFILE#"="RB"."FILE#" AND "U"."SEGBLOCK#"="RB"."BLOCK#")
filter("TS"."TS#"="U"."TS#")
34 - access("U"."TS#"="FI"."TS#" AND "U"."SEGFILE#"="FI"."RELFILE#")
35 - access("A"."TABLESPACE_NAME"="B"."TABLESPACE_NAME")
filter("A"."TABLESPACE_NAME"="B"."TABLESPACE_NAME")
44 - access("TS"."NAME"=:B1)
45 - filter(("FNNAM" IS NOT NULL AND "FNTYP"=4 AND "INST_ID"=USERENV('INSTANCE') AND BITAND("FNFLG",4)<>4))
46 - filter(("F"."SPARE1" IS NULL AND "F"."TS#"="TS"."TS#"))
47 - access("FNFNO"="F"."FILE#")
48 - filter("FE"."FENUM"="F"."FILE#")
54 - access("TS"."NAME"=:B1)
55 - filter(("FNNAM" IS NOT NULL AND "FNTYP"=4 AND "INST_ID"=USERENV('INSTANCE') AND BITAND("FNFLG",4)<>4))
56 - filter(("FNFNO"="HC"."KTFBHCAFNO" AND "HC"."KTFBHCTSN"="TS"."TS#"))
57 - filter("F"."SPARE1" IS NOT NULL)
58 - access("FNFNO"="F"."FILE#")
59 - filter("FE"."FENUM"="F"."FILE#")
60 - access("D"."TABLESPACE_NAME"="F"."TABLESPACE_NAME")
68 - filter(("FNNAM" IS NOT NULL AND "FNTYP"=4 AND "INST_ID"=USERENV('INSTANCE') AND BITAND("FNFLG",4)<>4))
69 - filter("F"."SPARE1" IS NULL)
70 - access("FNFNO"="F"."FILE#")
71 - filter("FE"."FENUM"="F"."FILE#")
73 - access("F"."TS#"="TS"."TS#")
78 - filter(("FNNAM" IS NOT NULL AND "FNTYP"=4 AND "INST_ID"=USERENV('INSTANCE') AND BITAND("FNFLG",4)<>4))
79 - filter("FNFNO"="HC"."KTFBHCAFNO")
80 - filter("F"."SPARE1" IS NOT NULL)
81 - access("FNFNO"="F"."FILE#")
82 - filter("FE"."FENUM"="F"."FILE#")
84 - access("HC"."KTFBHCTSN"="TS"."TS#")
92 - access("F"."TS#"="FI"."TS#" AND "F"."FILE#"="FI"."RELFILE#")
93 - filter(("TS"."BITMAPPED"=0 AND "TS"."TS#"="F"."TS#"))
96 - filter(("TS"."CONTENTS$"=0 AND "TS"."BITMAPPED"<>0 AND INTERNAL_FUNCTION("TS"."ONLINE$")))
97 - filter("TS"."TS#"="F"."KTFBFETSN")
98 - access("F"."KTFBFETSN"="FI"."TS#" AND "F"."KTFBFEFNO"="FI"."RELFILE#")
101 - access("TS"."TS#"="RB"."TS#")
103 - filter(("TS"."CONTENTS$"=0 AND "TS"."BITMAPPED"<>0 AND INTERNAL_FUNCTION("TS"."ONLINE$")))
104 - filter(("U"."KTFBUESEGTSN"="RB"."TS#" AND "U"."KTFBUESEGFNO"="RB"."FILE#" AND "U"."KTFBUESEGBNO"="RB"."BLOCK#"))
105 - access("RB"."TS#"="FI"."TS#" AND "U"."KTFBUEFNO"="FI"."RELFILE#")
111 - access("U"."TS#"="RB"."TS#" AND "U"."SEGFILE#"="RB"."FILE#" AND "U"."SEGBLOCK#"="RB"."BLOCK#")
112 - access("U"."TS#"="FI"."TS#" AND "U"."SEGFILE#"="FI"."RELFILE#")
113 - filter("TS"."BITMAPPED"=0)
114 - access("TS"."TS#"="U"."TS#")
192 rows selected.
Elapsed: 00:00:00.08
数据字典的统计信息刚使用 exec DBMS_STATS.GATHER_DICTIONARY_STATS; 收集过。
==========================================================================================================
解决办法：
清空回收站。
清空之后，1秒不到出结果。
阅读(1437) | 评论(0) | 转发(0) |
