Oracle partition size in Mb
by ivonko on Mar.17, 2010, under Development
Make connection as system or with user with “DBA” privilege
select partition_name,segment_name,
round(sum(bytes)/1024/1024,2) as Mb
from sys.dba_segments
where 1=1
and segment_name =’SOME_PARTITIONED_TABLE’ –table name
and tablespace_name = ‘USERS’ — tablespace name
and partition_name in (‘P16032010′,’P17032010’)
group by partition_name, segment_name
