/*查看表空间物理文件的名称及大小*/
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:APPBLJ-USERORADATAHTBASEHTBASE102.DBF' size 500M autoextend on next 5M maxsize unlimited;