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 vote155 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
0 vote182 views1 answer
Sintaxis SELECT sql
SQL
0 vote151 views1 answer
Add alternate add column sql
SQL
0 vote146 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
2 votes136 views1 answer
How to delete columns in sql
SQL
0 vote288 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
1 vote156 views3 answers
Drop unique key constraint in sql server
SQL
1 vote132 views3 answers
Grant syntax in sql
SQL
1 vote142 views1 answer
How to start with sql
SQL
1 vote148 views1 answer
ALL_TAB_PARTITIONS
SQL