设为首页 加入收藏

TOP

一个表空间使用率查询sql的优化(七)
2015-11-21 01:35:13 来源: 作者: 【 】 浏览:8
Tags:一个 空间 使用率 查询 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
首页 上一页 4 5 6 7 8 9 10 下一页 尾页 7/10/10
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
分享到: 
上一篇分区表:range分区,list分区,ha.. 下一篇MongoDB使用总结(C#版)

评论

帐  号: 密码: (新用户注册)
验 证 码:
表  情:
内  容: