SQL> select SEGMENT_NAME, PARTITION_NAME, SEGMENT_TYPE , TABLESPACE_NAME ,bytes/1024/1024 from user_segments where
segment_name like 'SMSG%' order by 2;
segment_name like 'SMSG%' order by 2;
SEGMENT_NAME PARTITION_NAME SEGMENT_TYPE TABLESPACE_NAME BYTES/1024/1024
-------------------- ------------------------------ ------------------ ------------------------------ ---------------
SMSG_LOGS P20130215 TABLE PARTITION PRODUCT 434
SMSG_LOGS P20130216 TABLE PARTITION PRODUCT 320
SMSG_LOGS P20130217 TABLE PARTITION PRODUCT 384
SMSG_LOGS P20130218 TABLE PARTITION PRODUCT .0625
SMSG_LOGS P20130219 TABLE PARTITION PRODUCT .0625