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

4 votes167 views3 answers
Check if two date ranges overlap sql server
SQL
2 votes174 views2 answers
Mysql alter column default
SQL
1 vote182 views1 answer
Age postgres
SQL
0 vote173 views1 answer
Incorrect datetime value sql table error 1292
SQL
11 votes201 views1 answer
Ddl view
SQL
2 votes175 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote177 views1 answer
Python sqlalchemy connection show server
SQL
0 vote169 views1 answer
Close sql query vb.net
SQL
0 vote164 views1 answer
Alter table name including schema
SQL
3 votes179 views1 answer
Oracle sql commit example
SQL