Advantages and disadvantages of ASSM and MSSM.
ASSM: advantage, support for large concurrent Inserts
: Disadvantages: the clustering factor of the index will be very poor-you can use reverse key indexes and Hash partitions.
MSSM does not support large concurrent inserts. Scan a large number of indexes, insert a small number of concurrent queries, and increase the order of index columns: MSSM is more suitable.
SYSTEM, rollback tablespace, and temporary tablespace are MSSM tablespaces
BYS @ bys3> select tablespace_name, EXTENT_MANAGEMENT, ALLOCATION_TYPE, SEGMENT_SPACE_MANAGEMENT from dba_tablespaces;
TABLESPACE_NAME EXTENT_MAN allow.o SEGMEN
----------------------------------------
SYSTEM LOCAL SYSTEM MANUAL
SYSAUX LOCAL SYSTEM AUTO
UNDOTBS1 LOCAL SYSTEM MANUAL
TEMP LOCAL UNIFORM MANUAL
USERS LOCAL SYSTEM AUTO
The SYSTEM tablespace is not ASSM. Why?
In SYSTEM, most of the base tables and dictionary tables are X $. Only DDL operations can modify these tables. In actual environments, there are not many DDL operations, so you can use MSSM.
The UNDO tablespace is not from ASSM. Why?
As mentioned at, UNDO assigns a transaction segment to each transaction, so there is no high concurrency operation problem.
Which of the following table spaces are not stored in ASSM by default.
The temporary tablespace is divided into multiple segments.
