Oracle db get table sizes

select segment_name, sum(bytes)/1024 KB 
from user_segments 
where segment_type='TABLE' and segment_name in (SELECT TABLE_NAME FROM ALL_TABLES) 
group by segment_name order by KB desc;

Similar codes

0 vote110 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL
0 vote108 views1 answer
Sql with example
SQL
0 vote105 views1 answer
Monthly Birthday SQL Query
SQL
0 vote99 views1 answer
Sql date between one week
SQL
14 votes109 views5 answers
Set password for postgres user ubuntu
SQL
21 votes124 views3 answers
Average sql
SQL
9 votes118 views2 answers
Convert data type in sql
SQL
0 vote129 views1 answer
Full outer join in mariadb mysql
SQL
3 votes97 views2 answers
Oracle synonym
SQL
0 vote60 views1 answer
Mysql convert column to uppercase
SQL