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

2 votes271 views2 answers
Exec procedure pl sql
SQL
1 vote297 views1 answer
Generate random data postgresql
SQL
0 vote289 views2 answers
How to display enum value sql server
SQL
0 vote279 views1 answer
Sql insert tuple
SQL
0 vote272 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
3 votes294 views2 answers
Laravel tosql with bindings
SQL
0 vote308 views1 answer
Pl/pgsql declare variable
SQL
7 votes280 views1 answer
Minecraft forge server host
SQL
0 vote307 views1 answer
Mysql config address
SQL
0 vote275 views2 answers
Database owner can't create new tables postgres
SQL