为什么临时表空间和系统表空间不能设为自动段管理

Maclean Liu(刘相兵

一个是历史遗留原因 字典底层表的一些配置固定为MSSM方式 如果改成ASSM会有额外的问题

欢迎补充

Stone

补充一点儿 :)

http://www.dba-oracle.com/art_builder_assm.htm

Limitations of ASSM

While ASSM appears exciting and simplifies the work of the Oracle DBA, there are several limitations on bitmap segment management in Oracle:

• Once allocated, the DBA has no control over the storage behavior of individual tables and indexes inside the tablespace.
  
• Large objects cannot use ASSM, and separate tablespaces must be created for tables that contain LOB datatypes.
  
• You cannot create a temporary tablespace with ASSM. This is because of the transient nature of temporary segments when sorting is performed.
  
• Only locally managed tablespaces can use bitmap segment management.
  

553722769

学习了解