用户表空间查询

查询用户表空间对应关系

select username, default_tablespace
from dba_users;

查询表空间使用情况

    select a.file_id "FileNo",a.tablespace_name  
    "Tablespace_name",  
    a.bytes "Bytes",a.bytes-sum(nvl(b.bytes,0)) "Used",  
    sum(nvl(b.bytes,0)) "Free",  
    sum(nvl(b.bytes,0))/a.bytes*100 "%free"  
    from dba_data_files a, dba_free_space b  
    where a.file_id=b.file_id(+)  
    group by a.tablespace_name ,  
    a.file_id,a.bytes order by a.tablespace_name;

转载

http://blog.csdn.net/guagua365/article/details/4138682