/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 vote154 views3 answers
Remove folders from remote git
SQL
2 votes235 views1 answer
Db.relationship sqlalchemy flask
SQL
0 vote146 views1 answer
Power query case when
SQL
0 vote164 views1 answer
Sqlalchemy sequence postgresql
SQL
0 vote165 views4 answers
Mysql replace regex
SQL
1 vote246 views1 answer
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
SQL
0 vote183 views1 answer
When mysql server would not work in xampp
SQL
0 vote154 views1 answer
Mysql subdate
SQL
15 votes311 views2 answers
Sql order by alphabetical
SQL
33 votes144 views2 answers
Postgres how to add field created at
SQL