|
(0)| 00:00:01 |
| 63 | NESTED LOOPS OUTER | | 1 | 58 | 3 (34)| 00:00:01 |
| 64 | VIEW | | 1 | 30 | 2 (50)| 00:00:01 |
| 65 | HASH GROUP BY | | 1 | 416 | 2 (50)| 00:00:01 |
| 66 | NESTED LOOPS | | 1 | 416 | 1 (0)| 00:00:01 |
| 67 | NESTED LOOPS | | 1 | 364 | 1 (0)| 00:00:01 |
| 68 | NESTED LOOPS | | 1 | 349 | 0 (0)| 00:00:01 |
|* 69 | FIXED TABLE FULL | X$KCCFN | 1 | 297 | 0 (0)| 00:00:01 |
|* 70 | FIXED TABLE FIXED INDEX | X$KTFTHC (ind:1) | 1 | 52 | 0 (0)| 00:00:01 |
| 71 | TABLE ACCESS CLUSTER | TS$ | 1 | 15 | 1 (0)| 00:00:01 |
|* 72 | INDEX UNIQUE SCAN | I_TS# | 1 | | 0 (0)| 00:00:01 |
|* 73 | FIXED TABLE FIXED INDEX | X$KCCTF (ind:1) | 1 | 52 | 0 (0)| 00:00:01 |
| 74 | VIEW PUSHED PREDICATE | | 1 | 28 | 1 (0)| 00:00:01 |
| 75 | SORT GROUP BY | | 1 | 90 | 1 (0)| 00:00:01 |
| 76 | NESTED LOOPS | | 1 | 90 | 1 (0)| 00:00:01 |
|* 77 | TABLE ACCESS BY INDEX ROWID | TS$ | 1 | 25 | 1 (0)| 00:00:01 |
|* 78 | INDEX UNIQUE SCAN | I_TS1 | 1 | | 0 (0)| 00:00:01 |
|* 79 | FIXED TABLE FIXED INDEX | X$KTFTHC (ind:2) | 1 | 65 | 0 (0)| 00:00:01 |
----------------------------------------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
3 - access("D"."TABLESPACE_NAME"="F"."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")
24 - access("HC"."KTFBHCTSN"="TS"."TS#")
25 - filter("F"."SPARE1" IS NOT NULL)
26 - access("FNFNO"="F"."FILE#")
27 - filter("FE"."FENUM"="F"."FILE#")
35 - filter("F"."FILE#"="FI"."RELFILE#")
36 - access("F"."TS#"="FI"."TS#")
37 - filter("TS"."BITMAPPED"=0)
38 - access("TS"."TS#"="F"."TS#")
41 - filter("TS"."CONTENTS$"=0 AND "TS"."BITMAPPED"<>0 AND ("TS"."ONLINE$"=1 OR
"TS"."ONLINE$"=4))
42 - filter("TS"."TS#"="F"."KTFBFETSN")
43 - access("F"."KTFBFETSN"="FI"."TS#" AND "F"."KTFBFEFNO"="FI"."RELFILE#")
49 - access("RB"."TS#"="FI"."TS#")
50 - filter("TS"."CONTENTS$"=0 AND "TS"."BITMAPPED"<>0 AND ("TS"."ONLINE$"=1 OR
"TS"."ONLINE$"=4))
51 - access("TS"."TS#"="RB"."TS#")
52 - filter("U"."KTFBUEFNO"="FI"."RELFILE#" AND "U"."KTFBUESEGTSN"="RB"."TS#" AND
"U"."KTFBUESEGFNO"="RB"."FILE#" AND "U"."KTFBUESEGBNO"="RB"."BLOCK#")
60 - access("U"."TS#"="RB"."TS#" AND "U"."SEGFILE#"="RB"."FILE#" AND
"U"."SEGBLOCK#"="RB"."BLOCK#")
filter("U"."TS#"="FI"."TS#" AND "U"."SEGFILE#"="FI"."RELFILE#")
61 - filter("TS"."BITMAPPED"=0)
62 - access("TS"."TS#"="U"."TS#")
69 - filter("V"."FNNAM" IS NOT NULL AND "V"."FNTYP"=7)
70 - filter("V"."FNFNO"="HC"."KTFTHCTFNO")
72 - access("HC"."KTFTHCTSN"="TS"."TS#")
73 - filter("TF"."TFDUP"<>0 AND BITAND("TF"."TFSTA",32)<>32 AND "V"."FNFNO"="TF"."TFNUM" AND
"TF"."TFFNH"="V"."FNNUM")
77 - filter("TS"."CONTENTS$"=1 AND "TS"."BITMAPPED"<>0 AND "TS"."ONLINE$"=1)
78 - access("TS"."NAME"="D"."TABLESPACE_NAME")
79 - filter("HC"."KTFTHCCVAL"=0 AND "HC"."INST_ID"=USERENV('INSTANCE') AND
"TS"."TS#"="HC"."KTFTHCTSN")
Statistics
----------------------------------------------------------
3472 recursive ca |