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 vote372 views1 answer
Oracle NLS_CHARACTERSET
SQL
1 vote345 views1 answer
Timestamp in sqlite
SQL
1 vote308 views1 answer
Strict in postgres SQL
SQL
0 vote370 views1 answer
Sql today at midnight
SQL
0 vote356 views1 answer
Linebreak sql
SQL
-1 vote391 views1 answer
Add 10 to all numbers in a column sql
SQL
0 vote356 views1 answer
Sqlite to csv statement
SQL
0 vote322 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
5 votes361 views2 answers
Mysql create database charset utf8mb4
SQL
0 vote387 views1 answer
Mysql update all record removing 2 hours from column
SQL