Oracle数据库top10物理段

select owner, name, type, mega, tbs
  from (select owner,
               case
                 when segment_type = 'LOBSEGMENT' then
                  logical_name
                 else
                  segment_name
               end as name,
               segment_type as type,
               round(bytes / 1024 / 1024) as mega,
               tablespace_name as tbs
          from (select a.owner,
                       a.segment_name,
                       a.segment_type,
                       b.table_name || '.' || b.column_name as logical_name,
                       bytes,
                       a.tablespace_name
                  from dba_segments a, dba_lobs b
                 where a.owner = b.owner(+)
                   and a.segment_name = b.segment_name(+)
                   and a.bytes > 1020 * 1024 * 1024)
         order by bytes desc);