- Query is:
1
2
3
4
5
6
7
select segment_name, sum(bytes) / 1024 / 1024 / 1024 GB
from user_segments
where segment_type = 'TABLE'
group by segment_name
order by GB desc;
Oracle sort tables by size
This post is licensed under CC BY 4.0 by the author.