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 vote366 views1 answer
Update and keep original value sql
SQL
0 vote410 views1 answer
Disable database droping sql
SQL
4 votes365 views2 answers
How to insert ip address in mysql using php
SQL
0 vote391 views1 answer
Declare or use variable in snowflake
SQL
0 vote348 views1 answer
Remove transient options sql wordpress
SQL
0 vote359 views2 answers
Msg 8164, Level 16, State 1, Procedure getSalaryMonth, Line 31 [Batch Start Line 13] An INSERT EXEC statement cannot be nested.
SQL
0 vote365 views1 answer
Import Data in MySQL without using any other software
SQL
9 votes395 views1 answer
Alter table column change data type to text mysql
SQL
11 votes398 views5 answers
Laravel db facade
SQL
10 votes387 views4 answers
Else if mysql
SQL