/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

1 vote142 views2 answers
Setval max id postgresql sequence
SQL
0 vote129 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
0 vote160 views1 answer
Mysql relationships between tables
SQL
-1 vote114 views2 answers
On update cascade
SQL
0 vote122 views2 answers
Pop sql insert value into
SQL
0 vote134 views1 answer
Drop column from local database postgres pgadmin
SQL
0 vote132 views1 answer
Reset keys in sql
SQL
8 votes137 views1 answer
Show mysql user table
SQL
0 vote86 views2 answers
Avg() sql
SQL
0 vote143 views1 answer
Mysql utc timestamp
SQL