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 vote107 views3 answers
How to verify sequence result in oracle SQL
SQL
27 votes112 views4 answers
Get all tables with column name sql
SQL
0 vote101 views1 answer
VSCode SQL Server Connection error
SQL
0 vote107 views1 answer
Oracle dynamic select into
SQL
0 vote133 views1 answer
How to check foreign key constraint in sql
SQL
12 votes107 views5 answers
Sql primary key
SQL
5 votes116 views1 answer
AND OR NOT operators sql
SQL
0 vote116 views1 answer
Resullt all update knex mysql
SQL
0 vote160 views1 answer
How to compile a function in oracle
SQL
0 vote108 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL