统计用户下的表的大小排行（包含大字段统计）

最新推荐文章于 2022-10-13 15:07:09 发布

launch_225

最新推荐文章于 2022-10-13 15:07:09 发布

阅读量748

点赞数

分类专栏： SQL

本文链接：https://blog.csdn.net/launch_225/article/details/8242398

版权

SQL 专栏收录该内容

48 篇文章 0 订阅

订阅专栏

select *
from (select owner, segment_name, sum(GB)
          from (select OWNER, SEGMENT_NAME, BYTES / 1024 / 1024 / 1024 GB
                  from dba_segments
                 where owner = ' USERNAME'
                   and segment_type = 'TABLE'
                   and segment_name not LIKE '%LOG%'
                union all
                select A.OWNER, B.TABLE_NAME, A.BYTES / 1024 / 1024 / 1024 GB
                  from dba_segments a, dba_lobs b
                 where a.owner = ' USERNAME'
                   and b.owner = ' USERNAME'
                   AND A.segment_name = B.SEGMENT_NAME
                   and a.segment_type = 'LOBSEGMENT'
                   AND b.table_name not like '%LOG%') a
         group by owner, segment_name
         order by 3 desc) bb
where rownum < 21