oralce 追加数据文件表空间

1、查询各个表空间使用的大小

SELECT tbs USERS, SUM (totalM) 总共大小M, SUM (usedM) 已使用空间M, SUM (remainedM) 剩余空间M, SUM (usedM) / SUM (totalM) * 100 已使用百分比, SUM (remainedM) / SUM (totalM) * 100 剩余百分比 FROM ( SELECT b.file_id ID, b.tablespace_name tbs, b.file_name NAME, b.bytes / 1024 / 1024 totalM, ( b.bytes - SUM (NVL(A .bytes, 0)) ) / 1024 / 1024 usedM, SUM (NVL(A .bytes, 0) / 1024 / 1024) remainedM, SUM ( NVL (A .bytes, 0) / (b.bytes) * 100 ), ( 100 - ( SUM (NVL(A .bytes, 0)) / (b.bytes) * 100 ) ) FROM dba_free_space A, dba_data_files b WHERE A .file_id = b.file_id GROUP BY b.tablespace_name, b.file_name, b.file_id, b.bytes ORDER BY b.tablespace_name ) GROUP BY tbs

2、查询需要扩容表空间的的数据文件路径

select * from dba_data_files where tablespace_name='USERS'; 3、对需要扩容的表空间增加数据文件 ALTER TABLESPACE USERS ADD DATAFILE 'D:\APP\11.2.0\GRID\ORADATA\DATA\USEREx.DBF' SIZE 32767M;