/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 vote231 views1 answer
Tsql table column constraint must be uppercase
SQL
2 votes224 views1 answer
Sql string_agg
SQL
2 votes239 views1 answer
Sql get the name of user pc
SQL
0 vote220 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL
1 vote202 views1 answer
Mysql date diff in seconds
SQL
9 votes196 views2 answers
Nosql databases
SQL
14 votes200 views3 answers
Delete all records from table except sql
SQL
0 vote204 views1 answer
Reona
SQL
2 votes206 views1 answer
Mysql add boolean column
SQL
0 vote194 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL