想查找哪些数据文件是自动增加的,但是INCREMENT_BY单位不知道是什么,还有怎么确定数据文件的最大值?
SQL> select FILE_NAME,TABLESPACE_NAME,AUTOEXTENSIBLE,MAXBYTES,INCREMENT_BY from dba_data_files;
FILE_NAME
--------------------------------------------------
TABLESPACE_NAME AUT MAXBYTES INCREMENT_BY
------------------------------ --- ---------- ------------
/opt/oracle/oradata/wapdb/system01.dbf
SYSTEM YES 3.4360E+10 1280
/opt/oracle/oradata/wapdb/undotbs01.dbf
UNDOTBS1 YES 3.4360E+10 640
/opt/oracle/oradata/wapdb/cwmlite01.dbf
CWMLITE YES 3.4360E+10 80
FILE_NAME
--------------------------------------------------
TABLESPACE_NAME AUT MAXBYTES INCREMENT_BY
------------------------------ --- ---------- ------------
/