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

19 votes287 views6 answers
Mysql if null
SQL
0 vote288 views1 answer
Excel vba import data to sql server
SQL
1 vote277 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
0 vote272 views1 answer
Sql server size of every table in a db
SQL
0 vote265 views2 answers
Find lowest number in sql
SQL
0 vote293 views1 answer
Update sql sintax
SQL
0 vote285 views1 answer
Reindex mssql table
SQL
1 vote266 views1 answer
Show table status command in mysql
SQL
0 vote281 views1 answer
Print mysql
SQL
6 votes329 views2 answers
Oracle undotbs usage
SQL