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 vote166 views1 answer
Mysql export search results
SQL
1 vote171 views3 answers
Psql: error: FATAL: role "postgres" does not exist
SQL
1 vote187 views1 answer
Mysql find tables with column name
SQL
0 vote232 views2 answers
Getting customers with no orders sql
SQL
6 votes191 views1 answer
To count number of rows in SQL table
SQL
0 vote178 views1 answer
How to use lower case in mysql
SQL
9 votes186 views4 answers
Last mysql
SQL
0 vote188 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL
0 vote166 views1 answer
List all permissions on a table in postgres
SQL
2 votes171 views1 answer
Oracle convert run_duration to number
SQL