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 vote201 views2 answers
Sql queries practice
SQL
0 vote188 views1 answer
Sqlalchemy one column of two has to be not null
SQL
0 vote193 views1 answer
Mysql range of dates overlap
SQL
0 vote209 views1 answer
When mysql server would not work in xampp
SQL
0 vote200 views1 answer
How to run mysql on terminal mac
SQL
0 vote225 views1 answer
Selecting Multiple Columns in SQL
SQL
244 votes477 views14 answers
Sql n insert
SQL
2 votes191 views2 answers
Sqlite_busy: database is locked
SQL
-1 vote203 views1 answer
Mysql delete duplicate rows except one
SQL
2 votes193 views1 answer
Mysql create user with mysql_native_password
SQL