segment size<=1m extent 按照64k分配;
segment size<=64m extent 按照1m分配;
segment size<=1g extent 按照8m分配;
segment size>1g extent 按照64m分配;
以前看doc这么介绍的,今天正好创建一了一个14g的大表,顺道观查了一下,做个记录
[@more@]16:54:38 SQL> select bytes/1024/1024/1024 from dba_segments where segment_name='T' and owner='SYS';
BYTES/1024/1024/1024
--------------------
14.25
已用时间: 00: 00: 00.18
16:54:48 SQL> select distinct bytes/1024/1024 extent_size from dba_extents where segment_name='T' and owner='SYS' order by extent_size;
EXTENT_SIZE
-----------
.0625
1
8
64
已用时间: 00: 00: 01.59
20:49:06 SQL>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/19602/viewspace-1049006/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/19602/viewspace-1049006/