SEGMENT_SPACE_MANAGEMENT auto

  • From: Roger Xu <wellmetus@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 29 Dec 2009 09:34:29 -0600

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
  1. Home
  2. oracle-l
  3. Archive
  4. 12-2009