oracle计算表的大小,计算oracle内数据量的大小,分区表，表分区。

select /*+parallel(t,8)*/sum(bytes)/1024/1024/1024  from dba_segments where segment_name  like '%DM_KPI_W_MOB_VAS_M1%';

create table DM_KPI_W_MOB_VAS_M1

(

MONTH_ID      VARCHAR2(6) not null,

PROV_ID       VARCHAR2(30),

AREA_NO       VARCHAR2(30),

CITY_NO       VARCHAR2(30),

CUST_TYPE     VARCHAR2(30),

CHANNEL_TYPE  VARCHAR2(30),

PRODUCT_CLASS VARCHAR2(30),

PAY_MODE      VARCHAR2(30),

TERM_TYPE     VARCHAR2(20),

CAP_TYPE      VARCHAR2(20),

BZ_TYPE1      VARCHAR2(30),

BZ_TYPE2      VARCHAR2(30),

VAS_TYPE      VARCHAR2(10),

KPI_CODE      VARCHAR2(30),

KPI_VALUE     NUMBER,

M_LM_VALUE    NUMBER,

Y_TY_VALUE    NUMBER,

M_LY_VALUE    NUMBER,

Y_LY_VALUE    NUMBER

)

partition by range (MONTH_ID)

(

partition PART200910 values less than ('200911')

tablespace TBS_MID_3G

pctfree 0

initrans 1

maxtrans 255

storage

(

initial 128K

minextents 1

maxextents unlimited

),

partition PART200911 values less than ('200912')

tablespace TBS_MID_3G

pctfree 0

initrans 1

maxtrans 255

storage

(

initial 128K

minextents 1

maxextents unlimited

),

partition PART200912 values less than ('201001')

tablespace TBS_MID_3G

pctfree 0

initrans 1

maxtrans 255

storage

(

initial 128K

minextents 1

maxextents unlimited

),

partition PART201001 values less than ('201002')

tablespace TBS_MID_3G

pctfree 0

initrans 1

maxtrans 255

storage

(

initial 128K

minextents 1

maxextents unlimited

),

partition PART201002 values less than ('201003')

tablespace TBS_MID_3G

pctfree 0

initrans 1

maxtrans 255

storage

(

initial 128K

minextents 1

maxextents unlimited

),

partition PART201003 values less than ('201004')

tablespace TBS_MID_3G

pctfree 0

initrans 1

maxtrans 255

storage

(

initial 128K

minextents 1

maxextents unlimited

),

partition PART201004 values less than ('201005')

tablespace TBS_MID_3G

pctfree 0

initrans 1

maxtrans 255

storage

(

initial 128K

minextents 1

maxextents unlimited

),

partition PART201005 values less than ('201006')

tablespace TBS_MID_3G

pctfree 0

initrans 1

maxtrans 255

storage

(

initial 128K

minextents 1

maxextents unlimited

),

partition PART201006 values less than ('201007')

tablespace TBS_MID_3G

pctfree 0

initrans 1

maxtrans 255

storage

(

initial 128K

minextents 1

maxextents unlimited

),

partition PART201007 values less than ('201008')

tablespace TBS_MID_3G

pctfree 0

initrans 1

maxtrans 255

storage

(

initial 128K

minextents 1

maxextents unlimited

),

partition PART201008 values less than ('201009')

tablespace TBS_MID_3G

pctfree 0

initrans 1

maxtrans 255

storage

(

initial 128K

minextents 1

maxextents unlimited

),

partition PART201009 values less than ('201010')

tablespace TBS_MID_3G

pctfree 0

initrans 1

maxtrans 255

storage

(

initial 128K

minextents 1

maxextents unlimited

),

partition PART201010 values less than ('201011')

tablespace TBS_MID_3G

pctfree 0

initrans 1

maxtrans 255

storage

(

initial 128K

minextents 1

maxextents unlimited

),

partition PART201011 values less than ('201012')

tablespace TBS_MID_3G

pctfree 10

initrans 1

maxtrans 255

storage

(

initial 128K

minextents 1

maxextents unlimited

),

partition PART201012 values less than ('201101')

tablespace TBS_MID_3G

pctfree 10

initrans 1

maxtrans 255

storage

(

initial 128K

minextents 1

maxextents unlimited

),

partition PART201101 values less than ('201102')

tablespace TBS_MID_3G

pctfree 10

initrans 1

maxtrans 255

storage

(

initial 128K

minextents 1

maxextents unlimited

),

partition PART201102 values less than ('201103')

tablespace TBS_MID_3G

pctfree 10

initrans 1

maxtrans 255

storage

(

initial 128K

minextents 1

maxextents unlimited

),

partition PART201103 values less than ('201104')

tablespace TBS_MID_3G

pctfree 10

initrans 1

maxtrans 255

storage

(

initial 128K

minextents 1

maxextents unlimited

),

partition PART201104 values less than ('201105')

tablespace TBS_MID_3G

pctfree 10

initrans 1

maxtrans 255

storage

(

initial 128K

minextents 1

maxextents unlimited

),

partition PART201105 values less than ('201106')

tablespace TBS_MID_3G

pctfree 10

initrans 1

maxtrans 255

storage

(

initial 128K

minextents 1

maxextents unlimited

),

partition PART201106 values less than ('201107')

tablespace TBS_MID_3G

pctfree 10

initrans 1

maxtrans 255

storage

(

initial 128K

minextents 1

maxextents unlimited

),

partition PART201107 values less than ('201108')

tablespace TBS_MID_3G

pctfree 10

initrans 1

maxtrans 255

storage

(

initial 128K

minextents 1

maxextents unlimited

),

partition PART201108 values less than ('201109')

tablespace TBS_MID_3G

pctfree 10

initrans 1

maxtrans 255

storage

(

initial 128K

minextents 1

maxextents unlimited

),

partition PART201109 values less than ('201110')

tablespace TBS_MID_3G

pctfree 10

initrans 1

maxtrans 255

storage

(

initial 128K

minextents 1

maxextents unlimited

),

partition PART201110 values less than ('201111')

tablespace TBS_MID_3G

pctfree 10

initrans 1

maxtrans 255

storage

(

initial 128K

minextents 1

maxextents unlimited

),

partition PART201111 values less than ('201112')

tablespace TBS_MID_3G

pctfree 10

initrans 1

maxtrans 255

storage

(

initial 128K

minextents 1

maxextents unlimited

),

partition PART201112 values less than ('201201')

tablespace TBS_MID_3G

pctfree 10

initrans 1

maxtrans 255

storage

(

initial 128K

minextents 1

maxextents unlimited

)

);