/*查看表空间物理文件的名称及大小*/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;