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 vote120 views1 answer
Sql change primary key to composite key
SQL
0 vote129 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
0 vote123 views1 answer
Sql count * vs count 1
SQL
0 vote136 views1 answer
Sql query to get contact form 7 fields
SQL
0 vote127 views1 answer
Typeorm raw sql
SQL
0 vote118 views1 answer
How to find username and password in oracle 18c
SQL
3 votes125 views2 answers
Mysql config user password
SQL
-2 votes132 views1 answer
Modify column name in tsql
SQL
3 votes132 views1 answer
Unsigned int in mysql
SQL
8 votes153 views1 answer
Mysql dump restore
SQL