存储空间可以用如下语句查:
select * from user_segments s where s.BYTES is not null order by s.BYTES desc
查记录条数可以用如下语句:
select * from user_tables t where t.NUM_ROWS is not null order by t.NUM_ROWS desc 。
oracle如何查询哪个表数据量大
最新推荐文章于 2022-08-03 10:20:09 发布
存储空间可以用如下语句查:
select * from user_segments s where s.BYTES is not null order by s.BYTES desc
查记录条数可以用如下语句:
select * from user_tables t where t.NUM_ROWS is not null order by t.NUM_ROWS desc 。