Oracle查询表大小,更新或查询太慢的时候

SELECT owner, segment_name, SUM(bytes /1024/1024 /1024) sum FROM dba_segments where owner = ‘用户' and segment_name = '表名' GROUP BY owner,segment_name

posted @ 2020-05-28 14:50  威尔逊  阅读(333)  评论(0编辑  收藏  举报