/SQL/Size of all tables in a schema oracle

Size of all tables in a schema oracle

SELECT sum(BYTES) / 1e6 AS SIZE_MB FROM DBA_SEGMENTS WHERE OWNER = 'schema_name';
-- By type
SELECT SEGMENT_TYPE, sum(BYTES) / 1e6 AS SIZE_MB FROM DBA_SEGMENTS
    WHERE OWNER = 'schema_name' GROUP BY SEGMENT_TYPE;
-- By schema
SELECT OWNER, sum(BYTES) / 1e6 AS SIZE_MB FROM DBA_SEGMENTS GROUP BY OWNER
    ORDER BY SIZE_MB DESC;

Similar codes

0 vote198 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
0 vote182 views1 answer
Limiting query result using where in sql
SQL
0 vote319 views1 answer
Sql alchemy escape ; in insert statement
SQL
0 vote228 views1 answer
Sql order by number not ordered
SQL
3 votes197 views3 answers
Stop mysql ubuntu
SQL
0 vote212 views1 answer
Disable database droping sql
SQL
0 vote201 views1 answer
Mysql add to number
SQL
0 vote200 views1 answer
Sql last 7 days
SQL
13 votes187 views2 answers
Sql count distinct group by
SQL
0 vote185 views1 answer
Sql date between one week
SQL