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 vote273 views1 answer
Replace content value from old to new sql
SQL
0 vote277 views1 answer
How to declare variable date in mysql
SQL
-1 vote300 views1 answer
Brisanje dupliranih konatakata
SQL
16 votes278 views4 answers
Find duplicates mysql
SQL
7 votes273 views6 answers
Nth highest salary in sql
SQL
7 votes294 views5 answers
Oracle alter table
SQL
0 vote264 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL
0 vote269 views1 answer
Sql server remove enter from string
SQL
0 vote287 views1 answer
Ms sql print more than 1 variable
SQL
14 votes285 views2 answers
Oracle add column with default value
SQL