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 vote117 views1 answer
Inner join distinct
SQL
0 vote123 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
1 vote112 views1 answer
DATE_SUB postgres
SQL
-1 vote73 views2 answers
Sql query examples
SQL
0 vote113 views1 answer
Ora 00001 error catch plsql
SQL
0 vote119 views1 answer
Postgres list all stored procedures query
SQL
0 vote121 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
0 vote125 views1 answer
Set Mamp mysql globally
SQL
0 vote124 views1 answer
Creation d'un trigger sql
SQL
0 vote124 views1 answer
Sql delete row from table where id
SQL