一个表空间使用率查询sql的优化(七)
TS#"[NUMBER,22], "FI"."RELFILE#"[NUMBER,22]
35 - "F".ROWID[ROWID,10], "F"."TS#"[NUMBER,22], "F"."FILE#"[NUMBER,22], "F"."LENGTH"[NUMBER,22]
36 - "F".ROWID[ROWID,10]
37 - "TS".ROWID[ROWID,10], "TS"."TS#"[NUMBER,22], "TS"."NAME"[VARCHAR2,30],
"TS"."BLOCKSIZE"[NUMBER,22], "TS"."BITMAPPED"[NUMBER,22]
38 - "TS".ROWID[ROWID,10]
39 - "TS"."NAME"[VARCHAR2,30], "TS"."BLOCKSIZE"[NUMBER,22], "F"."KTFBFEBLKS"[NUMBER,22]
40 - "TS"."NAME"[VARCHAR2,30], "TS"."BLOCKSIZE"[NUMBER,22], "F"."KTFBFETSN"[NUMBER,22],
"F"."KTFBFEFNO"[NUMBER,22], "F"."KTFBFEBLKS"[NUMBER,22]
41 - "TS"."TS#"[NUMBER,22], "TS"."NAME"[VARCHAR2,30], "TS"."BLOCKSIZE"[NUMBER,22]
42 - "F"."KTFBFETSN"[NUMBER,22], "F"."KTFBFEFNO"[NUMBER,22], "F"."KTFBFEBLKS"[NUMBER,22]
44 - "TS"."NAME"[VARCHAR2,30], "TS"."BLOCKSIZE"[NUMBER,22], "U"."KTFBUEBLKS"[NUMBER,22]
45 - "FI"."RELFILE#"[NUMBER,22], "RB"."TS#"[NUMBER,22], "RB"."FILE#"[NUMBER,22],
"RB"."BLOCK#"[NUMBER,22], "TS"."NAME"[VARCHAR2,30], "TS"."BLOCKSIZE"[NUMBER,22]
46 - "FI"."RELFILE#"[NUMBER,22], "RB"."TS#"[NUMBER,22], "RB"."FILE#"[NUMBER,22],
"RB"."BLOCK#"[NUMBER,22]
47 - "FI"."TS#"[NUMBER,22], "FI"."RELFILE#"[NUMBER,22]
48 - "RB"."TS#"[NUMBER,22], "RB"."FILE#"[NUMBER,22], "RB"."BLOCK#"[NUMBER,22]
49 - "RB".ROWID[ROWID,10], "RB"."TS#"[NUMBER,22]
50 - "TS".ROWID[ROWID,10], "TS"."TS#"[NUMBER,22], "TS"."NAME"[VARCHAR2,30],
"TS"."ONLINE$"[NUMBER,22], "TS"."CONTENTS$"[NUMBER,22], "TS"."BLOCKSIZE"[NUMBER,22],
"TS"."BITMAPPED"[NUMBER,22]
51 - "TS".ROWID[ROWID,10]
52 - "U"."KTFBUESEGTSN"[NUMBER,22], "U"."KTFBUESEGFNO"[NUMBER,22],
"U"."KTFBUESEGBNO"[NUMBER,22], "U"."KTFBUEFNO"[NUMBER,22], "U"."KTFBUEBLKS"[NUMBER,22]
53 - "U"."LENGTH"[NUMBER,22], "TS"."NAME"[VARCHAR2,30], "TS"."BLOCKSIZE"[NUMBER,22]
54 - "U"."TS#"[NUMBER,22], "U"."LENGTH"[NUMBER,22]
55 - "RB"."TS#"[NUMBER,22], "RB"."FILE#"[NUMBER,22], "RB"."BLOCK#"[NUMBER,22],
"FI"."TS#"[NUMBER,22], "FI"."RELFILE#"[NUMBER,22]
56 - "RB"."TS#"[NUMBER,22], "RB"."FILE#"[NUMBER,22], "RB"."BLOCK#"[NUMBER,22]
57 - (#keys=0) "FI"."TS#"[NUMBER,22], "FI"."RELFILE#"[NUMBER,22]
58 - "FI"."TS#"[NUMBER,22], "FI"."RELFILE#"[NUMBER,22]
59 - "U".ROWID[ROWID,10], "U"."TS#"[NUMBER,22], "U"."SEGFILE#"[NUMBER,22],
"U"."SEGBLOCK#"[NUMBER,22], "U"."LENGTH"[NUMBER,22]
60 - "U".ROWID[ROWID,10]
61 - "TS".ROWID[ROWID,10], "TS"."TS#"[NUMBER,22], "TS"."NAME"[VARCHAR2,30],
"TS"."BLOCKSIZE"[NUMBER,22], "TS"."BITMAPPED"[NUMBER,22]
62 - "TS".ROWID[ROWID,10]
63 - "D"."TABLESPACE_NAME"[VARCHAR2,30], "SPACE"[NUMBER,22], "USED_SPACE"[NUMBER,22],
"FREE_SPACE"[NUMBER,22]
64 - "D"."TABLESPACE_NAME"[VARCHAR2,30], "SPACE"[NUMBER,22]
65 - "TS"."NAME"[VARCHAR2,30], SUM(DECODE("HC"."KTFTHCCVAL",0,"HC"."KTFTHCSZ",NULL))[22],
SUM(DECODE("HC"."KTFTHCCVAL",0,"TS"."BLOCKSIZE"*"HC"."KTFTHCSZ",NULL))[22]
66 - "HC"."KTFTHCSZ"[NUMBER,22], "HC"."KTFTHCCVAL"[NUMBER,22], "TS"."NAME"[VARCHAR2,30],
"TS"."BLOCKSIZE"[NUMBER,22]
67 - "V"."FNNUM"[NUMBER,22], "V"."FNFNO"[NUMBER,22], "HC"."KTFTHCSZ"[NUMBER,22],
"HC"."KTFTHCCVAL"[NUMBER,22], "TS"."NAME"[VARCHAR2,30], "TS"."BLOCKSIZE"[NUMBER,22]
68 - "V"."FNNUM"[NUMBER,22], "V"."FNFNO"[NUMBER,22], "HC"."K