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 vote307 views1 answer
How to query all tables mysql at the same time
SQL
1 vote319 views1 answer
Postgresql escape single quote
SQL
0 vote294 views1 answer
Create table employees oracle
SQL
-1 vote309 views3 answers
Psql get last rows
SQL
6 votes342 views3 answers
Rename column ORACLE
SQL
0 vote332 views1 answer
How to get nth number in sql
SQL
1 vote298 views3 answers
Mariadb add foreign key
SQL
0 vote303 views1 answer
Uuid sqlalcomany
SQL
0 vote312 views2 answers
Reduce size of SQL server log file truncate - Source :NAYCode.com
SQL
0 vote321 views2 answers
Call to undefined function mysqli_fetch_all()
SQL