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

13 votes152 views2 answers
Sql join
SQL
2 votes137 views1 answer
Sql create database
SQL
0 vote156 views1 answer
Mysql regex select
SQL
1 vote166 views1 answer
How to give access to database in postgresql server to another user
SQL
0 vote156 views1 answer
Time mysql w3
SQL
0 vote171 views1 answer
How to check foreign key constraint in sql
SQL
23 votes143 views5 answers
Sql substring
SQL
0 vote130 views1 answer
Insert thai language sql server
SQL
0 vote140 views1 answer
How to fix mysql stop unexpectedly
SQL
10 votes138 views1 answer
Create table oracle
SQL