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 vote187 views1 answer
Index a database column sql
SQL
0 vote195 views1 answer
Sql search all columns of database oracle sql
SQL
0 vote199 views1 answer
How to make full text search dynamic in mysql
SQL
0 vote201 views3 answers
Run sql command line
SQL
1 vote209 views1 answer
Create new index takes long time postgresql
SQL
7 votes193 views1 answer
Mysql iif
SQL
0 vote186 views1 answer
List all functions and procedures in postgres query
SQL
5 votes199 views4 answers
Rollback to in sql
SQL
3 votes202 views2 answers
Postgres download
SQL
23 votes213 views4 answers
How to show all users in mysql
SQL