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

5 votes370 views2 answers
Sql conn
SQL
0 vote339 views1 answer
Laravel eloquent get generated sql
SQL
37 votes538 views3 answers
Sql check duplicate value in column
SQL
0 vote342 views1 answer
Get cpu details sql
SQL
4 votes335 views3 answers
Count with where
SQL
0 vote373 views1 answer
How to join result table in mysql
SQL
0 vote346 views1 answer
Sql select min row
SQL
1 vote354 views1 answer
Error code 1292 mysql workbench
SQL
3 votes393 views3 answers
Mysql auto increment after delete
SQL
0 vote343 views1 answer
Sql_inner_join
SQL