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
4 回答1.2k 阅读✓ 已解决
4 回答1.2k 阅读✓ 已解决
1 回答2.5k 阅读✓ 已解决
1 回答910 阅读✓ 已解决
1 回答697 阅读✓ 已解决
2 回答705 阅读✓ 已解决
3 回答693 阅读✓ 已解决