分区表大小查询

SELECT   owner,segment_name, SUM (BYTES) / 1024 / 1024
    FROM dba_extents
    where segment_type='TABLE PARTITION' and segment_name='AC08'
    group by owner,segment_name 
order by   1,3 desc