select * from request.segment_sizes where tablespace_name='TABLESPACE_NAME' order by rundate desc

select b.db_name, a.segment_name, bytes/1024/1024 size2 , segment_size , (bytes/1024/1024)-segment_size 
from dba_Segments a ,request.segment_sizes b
 where a.SEGMENT_NAME=b.SEGMENT_NAME and b.RUNDATE >= to_date('03-01-2014','dd-mm-yyyy')
 and b.tablespace_name='TABLESPACE_NAME' order by (bytes/1024/1024)-segment_size desc

select * from request.segment_sizes where RUNDATE >= to_date('03-01-2014','dd-mm-yyyy')
order by segment_size desc

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: