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

2 votes101 views1 answer
Oracle find unusable indexes
SQL
14 votes147 views1 answer
How to export db from mysql
SQL
0 vote105 views1 answer
Sql delete from with relation
SQL
1 vote94 views1 answer
Check constraint to check if date greater than todays date
SQL
0 vote107 views1 answer
Import sql in postgresql
SQL
0 vote135 views1 answer
Sql trigger to call stored procedure with parameters
SQL
3 votes130 views5 answers
Foreign keys
SQL
2 votes142 views1 answer
Username sql
SQL
0 vote102 views1 answer
Bitmap join index
SQL
1 vote107 views1 answer
Oracle apex prevent initial load
SQL