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 vote204 views1 answer
Sql alchemy escape ; in insert statement
SQL
5 votes190 views3 answers
Truncate function in sql oracle
SQL
4 votes189 views1 answer
Adding data to table in sql python
SQL
0 vote207 views1 answer
Datagrip execute procedure
SQL
0 vote187 views1 answer
Sql get table last modified time
SQL
-1 vote193 views1 answer
Condition in orderby mysql
SQL
3 votes192 views2 answers
Pl sql escape '
SQL
0 vote204 views2 answers
Create row number in sql
SQL
0 vote145 views1 answer
Mitigation of sql injection
SQL
0 vote185 views1 answer
Difference between cross apply and inner join
SQL