SEGMENT_SPACE_MANAGEMENT auto

Hi,

Is there any significant benefit to "convert" the following to AUTO
SEGMENT_SPACE_MANAGEMENT?

SQL> select tablespace_name, SEGMENT_SPACE_MANAGEMENT
  2  from dba_tablespaces
  3  where SEGMENT_SPACE_MANAGEMENT != 'AUTO';
TABLESPACE_NAME                SEGMEN
------------------------------ ------
SYSTEM                         MANUAL
UNDO                           MANUAL
TEMP                           MANUAL
SQL>

I know you cannot convert but recreate the tablespace. But how about SYSTEM?

Thanks,

Roger Xu

Other related posts:

  • » SEGMENT_SPACE_MANAGEMENT auto - Roger Xu