|
ND "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"))
Column Projection Information (identified by operation id):
-----------------------------------------------------------
1 - (#keys=1) STRDEF[22], STRDEF[30], STRDEF[22], STRDEF[22], STRDEF[22]
2 - STRDEF[30], STRDEF[22], STRDEF[22], STRDEF[22], STRDEF[22]
3 - (#keys=1) "D"."TABLESPACE_NAME"[VARCHAR2,30], "SPACE"[NUMBER,22], "FREE_SPACE"[NUMBER,22]
4 - "D"."TABLESPACE_NAME"[VARCHAR2,30], "SPACE"[NUMBER,22]
5 - "TABLESPACE_NAME"[VARCHAR2,30], SUM("BLOCKS")[22], SUM("BYTES")[22]
6 - "TABLESPACE_NAME"[VARCHAR2,30], "BYTES"[NUMBER,22], "BLOCKS"[NUMBER,22]
7 - STRDEF[30], STRDEF[22], STRDEF[22]
8 - "F"."BLOCKS"[NUMBER,22], "TS"."NAME"[VARCHAR2,30], "TS"."BLOCKSIZE"[NUMBER,22]
9 - "F"."BLOCKS"[NUMBER,22], "F"."TS#"[NUMBER,22]
10 - "F"."FILE#"[NUMBER,22], "F"."BLOCKS"[NUMBER,22], "F"."TS#"[NUMBER,22]
11 - "INST_ID"[NUMBER,22], "FNTYP"[NUMBER,22], "FNFNO"[NUMBER,22], "FNFLG"[NUMBER,22],
"FNNAM"[VARCHAR2,513]
12 - "F"."FILE#"[NUMBER,22], "F"."BLOCKS"[NUMBER,22], "F"."TS#"[NUMBER,22]
13 - "F".ROWID[ROWID,10], "F"."FILE#"[NUMBER,22]
14 - "FE"."FENUM"[NUMBER,22]
15 - "TS".ROWID[ROWID,10], "TS"."TS#"[NUMBER,22], "TS"."NAME"[VARCHAR2,30],
"TS"."BLOCKSIZE"[NUMBER,22]
16 - "TS".ROWID[ROWID,10]
17 - "HC"."KTFBHCSZ"[NUMBER,22], "HC"."KTFBHCCVAL"[NUMBER,22], "TS"."NAME"[VARCHAR2,30],
"TS"."BLOCKSIZE"[NUMBER,22]
18 - "HC"."KTFBHCSZ"[NUMBER,22], "HC"."KTFBHCCVAL"[NUMBER,22], "TS"."NAME"[VARCHAR2,30],
"TS"."BLOCKSIZE"[NUMBER,22], "F"."FILE#"[NUMBER,22]
19 - "FNFNO"[NUMBER,22], "HC"."KTFBHCSZ"[NUMBER,22], "HC"."KTFBHCCVAL"[NUMBER,22],
"TS"."NAME"[VARCHAR2,30], "TS"."BLOCKSIZE"[NUMBER,22]
20 - "FNFNO"[NUMBER,22], "HC"."KTFBHCTSN"[NUMBER,22], "HC"."KTFBHCSZ"[NUMBER,22],
"HC"."KTFBHCCVAL"[NUMBER,22]
21 - "INST_ID"[NUMBER,22], "FNTYP"[NUMBER,22], "FNFNO"[NUMBER,22], "FNFLG"[NUMBER,22],
"FNNAM"[VARCHAR2,513]
22 - "HC"."KTFBHCAFNO"[NUMBER,22], "HC"."KTFBHCTSN"[NUMBER,22], "HC"."KTFBHCSZ"[NUMBER,22],
"HC"."KTFBHCCVAL"[NUMBER,22]
23 - "TS".ROWID[ROWID,10], "TS"."TS#"[NUMBER,22], "TS"."NAME"[VARCHAR2,30],
"TS"."BLOCKSIZE"[NUMBER,22]
24 - "TS".ROWID[ROWID,10]
25 - "F"."FILE#"[NUMBER,22]
26 - "F".ROWID[ROWID,10], "F"."FILE#"[NUMBER,22]
27 - "FE"."FENUM"[NUMBER,22]
28 - "F"."TABLESPACE_NAME"[VARCHAR2,30], "FREE_SPACE"[NUMBER,22]
29 - "TABLESPACE_NAME"[VARCHAR2,30], SUM("BYTES")[22]
30 - "TABLESPACE_NAME"[VARCHAR2,30], "BYTES"[NUMBER,22]
31 - STRDEF[30], STRDEF[22]
32 - "F"."LENGTH"[NUMBER,22], "TS"."NAME"[VARCHAR2,30], "TS"."BLOCKSIZE"[NUMBER,22]
33 - "F"."TS#"[NUMBER,22], "F"."LENGTH"[NUMBER,22]
34 - "FI"." |