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 vote188 views1 answer
Select only one row sql
SQL
4 votes188 views1 answer
Phone number sql
SQL
15 votes386 views2 answers
How to sort names in alphabetical order in sql
SQL
0 vote228 views1 answer
Grouping by email domain mysql
SQL
0 vote255 views1 answer
Osm2pgsql mac
SQL
-2 votes201 views1 answer
How to open database
SQL
1 vote227 views1 answer
Ora-01109 database not open in oracle 19c
SQL
0 vote178 views1 answer
Mysql select last 15 minutes
SQL
0 vote215 views1 answer
Mysql get hour from datetime
SQL
0 vote208 views1 answer
Sql log file inof
SQL