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 vote190 views1 answer
Mysql changer nom table
SQL
1 vote116 views1 answer
Database run
SQL
0 vote165 views2 answers
How to find max and min salary in sql
SQL
1 vote184 views2 answers
Limit sqlserver
SQL
1 vote151 views4 answers
Sequelize migration default value
SQL
2 votes146 views1 answer
Mysql find tables with name
SQL
3 votes199 views2 answers
Oracle drop column
SQL
1 vote145 views1 answer
How refresh navicat tables to see new tables
SQL
5 votes157 views2 answers
Sql server port number
SQL
3 votes161 views3 answers
Mysqldump: couldn
SQL