SELECT a.tablespace_name,

ROUND (a.total_size) "total_size(MB)",

ROUND (a.total_size) - ROUND (b.free_size, 3) "used_size(MB)",

ROUND (b.free_size, 3) "free_size(MB)",

ROUND (b.free_size / total_size * 100, 2) || '%' free_rate

FROM ( SELECT tablespace_name, SUM (bytes) / 1024 / 1024 total_size

FROM dba_data_files

GROUP BY tablespace_name) a,

( SELECT tablespace_name, SUM (bytes) / 1024 / 1024 free_size

FROM dba_free_space

GROUP BY tablespace_name) b

WHERE a.tablespace_name = b.tablespace_name(+) order by ROUND (b.free_size / total_size * 100, 2);

查看表空间是不是自动增长

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 TABLESPACE_NAME, FILE_NAME;

修改增长数据文件增长

alter database datafile '/app/oradata/testdb/test.dbf' AUTOEXTEND on next 10M maxsize unlimited;

ITPub博客

表空间使用情况