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 vote287 views1 answer
Shows all databases created by user in ms sql
SQL
0 vote266 views1 answer
Oracle list of long running queries
SQL
0 vote282 views1 answer
Show tables in cassandra cql
SQL
0 vote299 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
1 vote248 views1 answer
Stop mysql server mac
SQL
0 vote270 views1 answer
Initcap in mysql
SQL
0 vote278 views1 answer
Sqlite löschen einer tabelle
SQL
1 vote261 views3 answers
Mysql disable foreign keys check
SQL
0 vote243 views1 answer
Mysql find non alphanumeric characters
SQL
0 vote297 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL