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

-1 vote304 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
0 vote311 views1 answer
Sql examples from your work
SQL
7 votes338 views1 answer
Oracle pagination query offset
SQL
6 votes340 views1 answer
Oracle rank
SQL
0 vote329 views2 answers
Sqlite unix timestamp
SQL
2 votes351 views1 answer
Metasploit start postgresql
SQL
0 vote338 views1 answer
Postgresql on conflict pair
SQL
0 vote397 views1 answer
Reindexing all tables sql server
SQL
0 vote350 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
0 vote323 views1 answer
Mysql could not fetch tables
SQL