oracle 表空间达到32g,oracle表空间到32G后扩容

/*查看表空间物理文件的名称及大小*/

SELECT tablespace_name,

file_id,

file_name,

round(bytes / (1024 * 1024), 0) total_space

FROM dba_data_files

ORDER BY tablespace_name;

/*查看表空间的使用情况*/

select 　　a.a1 表空间名称,

trunc(b.b3 / 1024 / 1024 / 1024, 2) 表空间总大小G,

trunc(b.b2 / 1024 / 1024 / 1024, 2) 表空间文件已有大小G, --同一表空间DBF文件目前大小总和

round((b.b2 - a.a2) / 1024 / 1024 / 1024, 2) 已使用G,

trunc(b.b2 / 1024 / 1024 / 1024 - (b.b2 - a.a2) / 1024 / 1024 / 1024,

2) 剩余大小G,

trunc((b.b3 / 1024 / 1024 - (b.b2 - a.a2) / 1024 / 1024) / 1024, 2) 可用表空间G

from 　　 (select tablespace_name a1, sum(nvl(bytes, 0)) a2

from dba_free_space

group by tablespace_name) a,

(select tablespace_name b1, sum(bytes) b2, sum(maxbytes) b3

from dba_data_files

group by tablespace_name) b

where a.a1 = b.b1;

/*增加表空间*/

alter tablespace HTBASE add datafile ‘D:\APP\BLJ-USER\ORADATA\HTBASE\HTBASE102.DBF‘ size 500M autoextend on next 5M maxsize unlimited;

原文：https://www.cnblogs.com/zlchust/p/14207678.html