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

1 vote128 views1 answer
Full sql mode
SQL
25 votes130 views4 answers
Import mysql dump command line
SQL
1 vote112 views1 answer
How to test for sql injection
SQL
1 vote123 views1 answer
SQL query to get all table records count from a database
SQL
0 vote123 views1 answer
A network or instance-specific error sql server
SQL
0 vote116 views1 answer
Shrink database file in sql server
SQL
10 votes120 views4 answers
SELECT FROM WHERE
SQL
0 vote135 views1 answer
Default password for mysql_secure_installation in mac
SQL
0 vote119 views1 answer
Search column name sql
SQL
0 vote111 views1 answer
Make a socket server to detect changes in mysql
SQL