recyclebin$里表太多引发的问题(六)
| 1 | 11 | 1 (0)| 00:00:01 |
|* 80 | INDEX UNIQUE SCAN | I_FILE1 | 1 | | 0 (0)| 00:00:01 |
|* 81 | FIXED TABLE FIXED INDEX | X$KCCFE (ind:1) | 1 | 13 | 0 (0)| 00:00:01 |
| 82 | TABLE ACCESS CLUSTER | TS$ | 1 | 13 | 1 (0)| 00:00:01 |
|* 83 | INDEX UNIQUE SCAN | I_TS# | 1 | | 0 (0)| 00:00:01 |
----------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
2 - access("B"."TABLESPACE_NAME"="C"."TABLESPACE_NAME")
3 - access("A"."TABLESPACE_NAME"="B"."TABLESPACE_NAME")
11 - filter("FNNAM" IS NOT NULL AND "FNTYP"=4 AND "INST_ID"=USERENV('INSTANCE') AND
BITAND("FNFLG",4)<>4)
12 - filter("F"."SPARE1" IS NULL)
13 - access("FNFNO"="F"."FILE#")
14 - filter("FE"."FENUM"="F"."FILE#")
16 - access("F"."TS#"="TS"."TS#")
21 - filter("FNNAM" IS NOT NULL AND "FNTYP"=4 AND "INST_ID"=USERENV('INSTANCE') AND
BITAND("FNFLG",4)<>4)
22 - filter("FNFNO"="HC"."KTFBHCAFNO")
23 - filter("F"."SPARE1" IS NOT NULL)
24 - access("FNFNO"="F"."FILE#")
25 - filter("FE"."FENUM"="F"."FILE#")
27 - access("HC"."KTFBHCTSN"="TS"."TS#")
35 - access("F"."TS#"="FI"."TS#" AND "F"."FILE#"="FI"."RELFILE#")
36 - filter("TS"."BITMAPPED"=0 AND "TS"."TS#"="F"."TS#")
39 - filter("TS"."CONTENTS$"=0 AND "TS"."BITMAPPED"<>
0 AND ("TS"."ONLINE$"=1 OR
"TS"."ONLINE$"=4))
40 - filter("TS"."TS#"="F"."KTFBFETSN")
41 - access("F"."KTFBFETSN"="FI"."TS#" AND "F"."KTFBFEFNO"="FI"."RELFILE#")
47 - access("TS"."TS#"="RB"."TS#")
filter("TS"."TS#"="RB"."TS#")
48 - filter("TS"."CONTENTS$"=0 AND "TS"."BITMAPPED"<>0 AND ("TS"."ONLINE$"=1 OR
"TS"."ONLINE$"=4))
49 - filter("U"."KTFBUESEGTSN"="RB"."TS#" AND "U"."KTFBUESEGFNO"="RB"."FILE#" AND
"U"."KTFBUESEGBNO"="RB"."BLOCK#")
50 - access("RB"."TS#"="FI"."TS#" AND "U"."KTFBUEFNO"="FI"."RELFILE#")
55 - access("U"."TS#"="FI"."TS#" AND "U"."SEGFILE#"="FI"."RELFILE#")
56 - filter("U"."SEGFILE#"="RB"."FILE#" AND "U"."SEGBLOCK#"="RB"."BLOCK#")
57 - access("U"."TS#"="RB"."TS#")
58 - filter("TS"."BITMAPPED"=0)
59 - access("TS"."TS#"="U"."TS#")
67 - filter("FNNAM" IS NOT NULL AND "FNTYP"=4 AND "INST_ID"=USERENV('INSTANCE') AND
BITAND("FNFLG",4)<>4)
68 - filter("F"."SPARE1" IS NULL)
69 - access("FNFNO"="F"."FILE#")
70 - filter("FE"."FENUM"="F"."FILE#")
72 - access("F"."TS#"="TS"."TS#")
77 - filter("FNNAM" IS NOT NULL AND "FNTYP"=4 AND "INST_ID"=USERENV('INSTANCE') AND
BITAND("FNFLG",4)<>4)
78 - filter("FNFNO"="HC"."KTFBHCAFNO")
79 - filter("F"."SPARE1" IS NOT NULL)
80 - access("FNFNO"="F"."FILE#")
81 - filter("FE"."FENUM"="F"."FILE#")
83 - access("HC"."KTFBHCTSN"="TS"."TS#")
140 rows selected.