表空间脚本存储参数的理解

CREATE TABLESPACE FMMES_IDX01 DATAFILE
  '/PHACW_D01/date/fmmes_idx01.dbf' SIZE 6110M AUTOEXTEND ON NEXT 10M MAXSIZE 8192M,
  '/PHACW_D01/date/fmmes_idx011.dbf' SIZE 6090M AUTOEXTEND ON NEXT 10M MAXSIZE 8192M
LOGGING
ONLINE
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT AUTO
FLASHBACK ON;

参数解析：
LOGGING:記錄日誌模式，默認值，屬性會覆蓋表空間上建立的table,index
PERMANENT:永久表空間，另外兩個值為Temporary ,Undo
EXTENT MANAGEMENT LOCAL AUTOALLOCATE: 區大小為系統自動分配，另外一種方式為 uniform size 1M 指定區大小1M
BLOCKSIZE 8K: 指定數據塊大小8K
FLASHBACK ON：是否支持閃回
SEGMENT SPACE MANAGEMENT AUTO：段空間自動管理，即ASSM，MANUAL為手動管理,官方解釋：
AUTO 
Specify AUTO if you want the database to manage the freespace of segments in the tablespace using a bitmap. If you specifyAUTO, then the database ignores any specification for PCTUSED, FREELIST, and FREELIST GROUPS in subsequent storage specifications for objects in this tablespace. This setting is called automaticsegment-space management and is the default.

MANUAL
Specify MANUAL if you want the database to manage the freespace of segments in the tablespace using free lists. Oracle strongly recommends that you do not use this setting and that you create tablespaces with automaticsegment-space management.

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29564184/viewspace-1140395/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29564184/viewspace-1140395/