---所有表空间占用情况
select a.TABLESPACE_NAME TablespaceName,sum(a.bytes/1024/1024/1024) totle_size,sum(nvl(b.free_space1/1024/1024/1024,0)) free_space
,sum(a.bytes/1024/1024/1024)-sum(nvl(b.free_space1/1024/1024/1024,0)) used_space
,round((sum(a.bytes/1024/1024/1024)-sum(nvl(b.free_space1/1024/1024/1024,0)))*100/sum(a.bytes/1024/1024/1024),2) used_percent
from dba_data_files a,(select sum(nvl(bytes,0)) free_space1,file_id
from dba_free_space group by file_id) b where a.file_id = b.file_id(+) --and a.tablespace_name like 'TBS_TSS_LIST_01'
group by a.TABLESPACE_NAME order by used_percent desc
select tablespace_name 表空间,segment_name 表名,partition_name 分区名, segment_name,round(bytes/1024/1024/1024,2) 大小_G,sysdate from user_segments
--where tablespace_name='liems3' --and segment_name='TL_F6_FORMAT_LIST_201309'
order by segment_name,partition_name,bytes desc ;