确定system 与sysaux 表空间是否自动扩展

  使用命令： select tablespace_name, AUTOEXTENSIBLE,INCREMENT_BY from dba_data_files;

查询表空间使用情况的语句：

select *

  from (select Q2.OTHER_TNAME TS_NAME,

               PIECES,

               TS_SIZE TS_SIZE,

               NVL(LARGEST_CHUNK, 0) LARGESTPC,

               NVL(TOTAL_FREE, 0) TOTALFREE,

               NVL(ROUND((TOTAL_FREE / TS_SIZE) * 100, 2), 0) PCT_FREE,

               TS_SIZE - TOTAL_FREE WHATSUSED,

               NVL(100 - ROUND((TOTAL_FREE / TS_SIZE) * 100, 2), 100) PCT_USED,

               decode(nvl(100-round((total_free/ts_size)*100,0),100),

                 85,'+',86,'+',87,'+',88,'+',89,'++',90,'++',91,'++',

                 92,'++',93,'++',94,'+++',95,'+++',96,'+++',97,'++++',

                 98,'+++++',99,'+++++',100,'+++++','') PROBLEM

          from (select DFS.TABLESPACE_NAME,

                       count(*) PIECES,

                       ROUND(max(DFS.BYTES) / 1024 / 1024, 2) LARGEST_CHUNK,

                       ROUND(sum(DFS.BYTES) / 1024 / 1024, 2) TOTAL_FREE

                  from DBA_FREE_SPACE DFS

                 group by TABLESPACE_NAME) Q1,

               (select TABLESPACE_NAME OTHER_TNAME,

                       ROUND(sum(DDF2.BYTES) / 1024 / 1024, 2) TS_SIZE

                  from DBA_DATA_FILES DDF2

                 group by TABLESPACE_NAME) Q2

         where Q2.OTHER_TNAME = Q1.TABLESPACE_NAME(+)

         order by NVL(100 - ROUND((TOTAL_FREE / TS_SIZE) * 100, 0), 100) desc) T

  where ROWNUM < 20;

确定system 与sysaux 表空间是否自动扩展

  使用命令： select tablespace_name, AUTOEXTENSIBLE,INCREMENT_BY from dba_data_files;

                                         -----------------未完待续