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 vote329 views1 answer
Mysqldump: error:
SQL
9 votes548 views2 answers
Current date in postgresql minus 1 day
SQL
8 votes284 views2 answers
Mysql query dates between two dates
SQL
0 vote303 views1 answer
Selecting from a view SQL
SQL
1 vote305 views1 answer
Postgresql export output table as a csv
SQL
3 votes298 views1 answer
Créer une table sql
SQL
6 votes296 views5 answers
Sql add months to date
SQL
0 vote301 views1 answer
Sql stored procedure update if parameter is not null
SQL
0 vote285 views1 answer
Mysql Error Code: 1005
SQL
2 votes289 views1 answer
Mysql find tables with name
SQL