查询数据库大于1G的表

最新推荐文章于 2024-03-28 15:11:30 发布

weixin_30809173

最新推荐文章于 2024-03-28 15:11:30 发布

阅读量335

点赞数

文章标签：数据库 python

原文链接：http://www.cnblogs.com/lishoubin/archive/2013/05/13/3211283.html

版权

select a.owner, a.table_name, tt.total, a.partitioned
from dba_tables a,
       (select t.owner,
               t.segment_name,
               trunc(sum(t.bytes) / 1024 / 1024 / 1024) as total
          from dba_segments t
         where t.segment_type like 'TABLE%'
         group by t.owner, t.segment_name
        having sum(t.bytes) / 1024 / 1024 > 1024) tt
where a.owner = tt.owner
   and a.table_name = tt.segment_name;

转载于:https://www.cnblogs.com/lishoubin/archive/2013/05/13/3211283.html