ITPub博客

select a.segment_name,       a.segment_type,       a.bytes,       a.bytes / 1024 / 1024 byte_m,       b.created  from dba_segments a inner join all_objects b    on b.object_type = 'TABLE'   and a.owner = b.owner   and a.segment_name = b.object_name where a.owner = 'STATUSER'   and a.segment_type = 'TABLE' /* and a.bytes>500