查看Oracle数据库最大的几张表

查询Oracle某个表空间最大的几张表，查看Oracle数据库占用表空间最大的表，查看表空间增长最快的几张表

set linesize 300 pagesize 300
select *
  from (SELECT s.owner,
               s.segment_name AS table_name,
               ROUND(SUM(s.bytes) / 1024 / 1024, 2) AS size_mb,
               t.num_rows
          FROM dba_segments s
          LEFT JOIN dba_tables t
            ON s.owner = t.owner
           AND s.segment_name = t.table_name
         WHERE s.tablespace_name = 'RP_TBS'
         GROUP BY s.owner, s.segment_name, t.num_rows
         ORDER BY SUM(s.bytes) DESC)
 where rownum < 20;