freelist 治理空闲段
日期：2014-05-16 浏览次数：20532 次
关于freelists的官方文档：
SQL Reference--------CREATE TABLESPACE------------‘segment_management_clause‘
SQL Reference--------CREATE TABLESPACE---------storage_clause------搜索‘freelist’
1、创建测试表空间EXAMPLE
SYS@PROD>CREATE TABLESPACE example
2 DATAFILE'/u01/app/oracle/oradata/PROD/disk1/EXAMPLE_01.dbf'
3 SIZE 400M
4*SEGMENT SPACE MANAGEMENT MANUAL;
Tablespace created.
2、了解关于表空间的数据字典
SYS@PROD>desc dba_tablespaces;
Name Null? Type
------------------------------------------------- ----------------------------
TABLESPACE_NAME NOT NULLVARCHAR2(30)
BLOCK_SIZE NOT NULL NUMBER
INITIAL_EXTENT NUMBER
NEXT_EXTENT NUMBER
MIN_EXTENTS NOT NULL NUMBER
MAX_EXTENTS NUMBER
PCT_INCREASE NUMBER
MIN_EXTLEN NUMBER
STATUS VARCHAR2(9)
CONTENTS VARCHAR2(9)
LOGGING VARCHAR2(9)
FORCE_LOGGING &nbs
