mysql数据库初始大小_分区默认segment大小变化(64k—>8M)

在11.2.0.3(从11.2.0.2开始)创建分区表,每个分区默认大小为8M,是由_partition_large_extents参数控制,可以算是11.2.0.2开始的一个新特性,为了减少extent数量,提高分区表性能,而设置的一个参数,默认为true，即分区表的每个extent为8M,这里对于_partition_large_extents为true和false的情况进行了测试

_partition_large_extents=true

SQL> select * from v$version;

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production

PL/SQL Release 11.2.0.3.0 - Production

CORE 11.2.0.3.0 Production

TNS for Linux: Version 11.2.0.3.0 - Production

NLSRTL Version 11.2.0.3.0 - Production

SQL> show parameter deferred_segment_creation

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

deferred_segment_creation boolean TRUE

SQL> show parameter _partition_large_extents;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

_partition_large_extents string FALSE

SQL> create table test_com_partition_1

2 (

3 name varchar2(4000) not null,

4 aaaaa number not null,

5 bbbbb varchar2(180) not null,

6 ccccc varchar2(4000),

7 constraint pk_test_com_partition_1 primary key(name)

8 )

9 partition by range(aaaaa) interval (1)

10 subpartition by range (bbbbb)

11 subpartition template

12 (

13 subpartition sp_2008 values less than ('2009') tablespace sp_2008,

14 subpartition sp_2009 values less than ('2010') tablespace sp_2009,

15 subpartition sp_2010 values less than ('2011') tablespace sp_2010,

16 subpartition sp_2011 values less than ('2012') tablespace sp_2011,

17 subpartition sp_2012 values less than ('2013') tablespace sp_2012,

18 subpartition sp_2013 values less than ('2014') tablespace sp_2013,

19 subpartition sp_2014 values less than ('2015') tablespace sp_2014,

20 subpartition sp_2015 values less than ('2016') tablespace sp_2015,

21 subpartition sp_2016 values less than ('2017') tablespace sp_2016,

22 subpartition sp_2017 values less than ('2018') tablespace sp_2017,

23