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 vote209 views1 answer
Postgresql update to unique
SQL
0 vote230 views2 answers
CREATE OR REPLACE FUNCTION
SQL
2 votes223 views1 answer
Query to check cpu utilization in oracle database
SQL
1 vote223 views3 answers
Date_add mysql
SQL
0 vote217 views1 answer
Import sql dump into postgresql database
SQL
3 votes209 views2 answers
Mysql time
SQL
3 votes219 views2 answers
Enter mysql command line
SQL
0 vote210 views1 answer
Inner joint
SQL
5 votes236 views4 answers
Traduction
SQL
0 vote213 views1 answer
EnvironmentError: mysql_config not found
SQL