Oracle schema size

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 vote328 views1 answer
Sql how to display two atributes as one in sql
SQL
1 vote336 views1 answer
Postgresql reset serial counter after deleting content
SQL
2 votes340 views1 answer
Add new column not null sql server
SQL
0 vote357 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
0 vote349 views1 answer
Psql attribute cannot login
SQL
1 vote344 views2 answers
Sql left characters
SQL
0 vote370 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
0 vote328 views2 answers
Return the number of records in a single table mysql
SQL
11 votes315 views2 answers
Having keyword sql
SQL
2 votes322 views1 answer
Sql ignore accents
SQL