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 vote171 views1 answer
Sql count * vs count 1
SQL
0 vote165 views1 answer
Sql comparison operators
SQL
19 votes174 views6 answers
What is mySQL
SQL
0 vote170 views1 answer
Shell script to log mysql cpu usage
SQL
1 vote204 views1 answer
Insert value to new table by joining 2 different tables
SQL
0 vote171 views1 answer
Mql5 datetime get hour
SQL
1 vote180 views1 answer
Sql server 2016 reseed identity
SQL
0 vote184 views1 answer
Mysql preg replace
SQL
5 votes184 views1 answer
Sql add column after another
SQL
4 votes174 views2 answers
Tables in sql
SQL