查询表空间和数据文件对应关系的方法

对应关系 select username,default_tablespace from dba_users;
总的大小 select tablespace_name, file_id, file_name,
round(bytes/(1024*1024),0) total_space
from dba_data_files
order by tablespace_name;
剩余的大小 SELECT TABLESPACE_NAME,SUM(BYTES)/1024/1024 MB
           FROM DBA_FREE_SPACE GROUP BY TABLESPACE_NAME;
已用空间: Select Tablespace_Name,Sum(bytes)/1024/1024 From Dba_Segments Group By Tablespace_Name
查询表拓展空间的大小 select * from dba_tablespaces where TABLESPACE_NAME='USERS'