select table_name, round((num_rows * avg_row_len)/1024/1024,2) as size1 from user_tables where num_rows!=0 and avg_row_len!=0 order by size1 desc
select table_name, round((num_rows * avg_row_len)/1024/1024,2) as size1 from user_tables where num_rows!=0 and avg_row_len!=0 order by size1 desc
7 回答5.6k 阅读
8 回答6.5k 阅读
4 回答4.2k 阅读
4 回答687 阅读✓ 已解决
2 回答3.4k 阅读
2 回答966 阅读✓ 已解决
1 回答2.5k 阅读✓ 已解决