/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 vote187 views1 answer
Postgresql linux password
SQL
0 vote176 views1 answer
Adding primery key constraint to a column
SQL
1 vote165 views1 answer
Can we drop a primary key
SQL
0 vote177 views1 answer
Sql server count all tables rows
SQL
0 vote164 views2 answers
Update information in a mysql column
SQL
7 votes175 views2 answers
MySQL IF without else
SQL
5 votes164 views2 answers
Sql conn
SQL
2 votes194 views2 answers
Spring where to put the data sql
SQL
3 votes195 views4 answers
Psql list tables in schema
SQL
0 vote196 views1 answer
Primary key start from number
SQL