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 vote289 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
0 vote305 views1 answer
Addition of 2 column value in mysql
SQL
0 vote311 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
2 votes293 views1 answer
Oracle table size
SQL
3 votes320 views2 answers
Postgres download
SQL
5 votes314 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
0 vote299 views1 answer
Separator mysql
SQL
0 vote378 views2 answers
Mysql insert rows to another database
SQL
0 vote353 views1 answer
Postgres list all triggers
SQL
0 vote300 views1 answer
Dapper run sql script with parameters
SQL