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

prewind

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

 

http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10739/partiti.htm

 

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
    )
);