1.查询表空间占用情况
select df.tablespace_name,SUM(df.bytes)/1024/1024 total,SUM(fs.bytes)/1024/1024 free,SUM(df.bytes-fs.bytes)/1024/1024 used from dba_data_files df,dba_free_space fs
where df.tablespace_name = fs.tablespace_name
group by df.tablespace_name
2.查询表占用空间情况
SELECT t.owner, t.segment_name,sum(bytes)/1024/1024 From dba_segments t
WHERE t.tablespace_name = 'NEWAPP'
GROUP by t.owner,t.segment_name
ORDER BY SUM(bytes) desc;