达梦统计所有表的数据量
<p>先收集统计信息
统计信息收集后执行sql
select t.owner, t.table_name, t.tablespace_name, t.num_rows, t.last_analyzed
from dba_tables t
where t.owner = 'ZJS_CGW_YL' -- 用户/模式名
order by t.num_rows desc;
<img src="http://60.191.64.5:16100/server/index.php?s=/api/attachment/visitFile/sign/1d6fd75e8e1fcca920f5536ecda46b70" alt="" /></p>