oracle查看表中数据的大小

通过从视图 user_segments的字段 bytes中找到

select SUM(bytes)/1024/1024 from user_segments where segment_name='EMP';

select segment_name,sum(bytes)/1024/1024 as MB from user_segments group by segment_name order by MB desc; 

posted @ 2017-07-21 09:48  酸奶加绿茶  阅读(3715)  评论(0编辑  收藏  举报