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

31 votes204 views3 answers
Sql count(*)
SQL
16 votes279 views2 answers
Sql vs nosql
SQL
1 vote221 views1 answer
Mysql how to reset primary key
SQL
1 vote214 views1 answer
Show per page table in xampp
SQL
0 vote228 views1 answer
Sql server change schema of a table
SQL
0 vote229 views1 answer
Sql statement show all emails with dome
SQL
4 votes211 views1 answer
What are the data types in sql
SQL
0 vote217 views2 answers
Oracle create chain rule
SQL
2 votes220 views1 answer
Apex execute batch job
SQL
1 vote225 views4 answers
Alter schema sql
SQL