ASSM是Automatic Segment Space Management的缩写。与ASSM相对是Manul Segment Space Management。只有在Locally Managed Tablespace中可以使用ASSM,system tablespace不可以使用ASSM。Locally managed tablespace和ASSm是11gR2的默认配置。
In a locally managed tablespace, following parameters are not used any more:
- next
- pctincrease
- minextents
- maxentents
- default
ASSM uses bitmap to manage space, whereas MSSM uses free list to manage free space.
在创建Tablespace时可以显式指定:
create tablespace tools
datafile '/ora01/dbfile/INVREP/tools01.dbf'
size 100m -- Fixed datafile size
extent management local -- Locally managed
uniform size 128k -- Uniform extent size
segment space management auto -- ASSM
表空间tools虽然采用ASSM,但是空间超出100M后,依然需要手工增长。或者增加datafile。亦即,表空间存储空间的上限是有数据文件的属性决定的,不是ASSM。
ASSM的参数比MSSM少许多,一个 Pctfree就够了。以下参数不再需要- pctused
- freelist
- freelist group
select tablespace_name ,extent_management ,segment_space_management
from dba_tablespaces
order by tablespace_name;