查看表空间
SQL>select * from v$tablespace;

查询数据文件
SQL>select * from v$datafile;

查询表空间与数据文件的对应情况
SQL>select t.name,f.path from v$tablespace,v$datafile f where t.id=f.group_id;

查询表空间使用情况
SQL>select t.name tablespace_name,
f.free_sizesf_get_page_size()/1024/1024||'M' free_space,
f.total_sizesf_get_page_size()/1024/1024||'M' total_space,
f.free_size*100/f.total_size "% free"
from v$tablespace t, v$datafile f
where t.id=f.group_id;