查看表空间使用情况

SELECT UPPER( F.TABLESPACE_NAME ) "表空间名", D.TOT_GROOTTE_MB "表空间大小(M)", D.TOT_GROOTTE_MB - F.TOTAL_BYTES "已使用空间(M)", TO_CHAR( ROUND( ( D.TOT_GROOTTE_MB - F.TOTAL_BYTES ) / D.TOT_GROOTTE_MB * 100, 2 ), '990.99' ) "使用比", F.TOTAL_BYTES "空闲空间(M)", F.MAX_BYTES "最大块(M)" FROM ( SELECT TABLESPACE_NAME, ROUND( SUM( BYTES ) / ( 1024 * 1024 ), 2 ) TOTAL_BYTES, ROUND( MAX( BYTES ) / ( 1024 * 1024 ), 2 ) MAX_BYTES FROM SYS.DBA_FREE_SPACE GROUP BY TABLESPACE_NAME ) F, ( SELECT DD.TABLESPACE_NAME, ROUND( SUM( DD.BYTES ) / ( 1024 * 1024 ), 2 ) TOT_GROOTTE_MB FROM SYS.DBA_DATA_FILES DD GROUP BY DD.TABLESPACE_NAME ) D WHERE D.TABLESPACE_NAME = F.TABLESPACE_NAME ORDER BY 4 DESC;

查看表空间是否自增及最大空间

SELECT T.TABLESPACE_NAME "表空间", D.FILE_NAME "数据文件", D.AUTOEXTENSIBLE "是否自增", D.BYTES "当前大小", D.MAXBYTES "最大值", D.STATUS "状态" FROM DBA_TABLESPACES T, DBA_DATA_FILES D WHERE T.TABLESPACE_NAME = D.TABLESPACE_NAME ORDER BY T.TABLESPACE_NAME, D.FILE_NAME;

只修改表空间最大值

ALTER database DATAFILE 'D:\DataBase\SYSTEM.DBF' autoextend ON maxsize 5000m;

修改表空间最大值及每次自增大小

ALTER database datafile 'D:\DataBase\SYSTEM.DBF' autoextend ON NEXT 200m maxsize 5000m;