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 votes195 views1 answer
Convert series number to date in sql
SQL
1 vote214 views1 answer
Insert value to new table by joining 2 different tables
SQL
22 votes231 views3 answers
Sql cheat sheet
SQL
0 vote191 views1 answer
Oracle NLS_CHARACTERSET
SQL
0 vote191 views1 answer
How to order result of subquery in select
SQL
2 votes196 views2 answers
Postgres select duplicate columns
SQL
0 vote190 views1 answer
C# check if mysql query modified rows
SQL
0 vote202 views1 answer
Mysql milliseconds
SQL
1 vote189 views1 answer
Oracle sql listagg
SQL
6 votes251 views2 answers
How to get yesterday date in mysql
SQL