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 vote315 views1 answer
How to find date from date table in sql
SQL
0 vote279 views1 answer
Mysql disable query caching
SQL
1 vote276 views1 answer
Adding a check statement in sql
SQL
0 vote286 views1 answer
Oracle remove line breaks
SQL
4 votes290 views2 answers
Sql offset
SQL
0 vote267 views2 answers
SQL Server Standard
SQL
4 votes321 views2 answers
Postgresql float data type
SQL
0 vote279 views2 answers
How to check if sqlite table exists in nodejs
SQL
0 vote296 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
-1 vote291 views1 answer
Spring boot mysql connection properties
SQL