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

-1 vote135 views1 answer
How to use update trigger in sql
SQL
9 votes169 views6 answers
Oracle substring
SQL
9 votes145 views1 answer
Oracle get table schema
SQL
0 vote191 views1 answer
Updating database in sql
SQL
1 vote170 views1 answer
Mysql return text after a final full stop
SQL
1 vote144 views2 answers
T-sql random number for each row
SQL
10 votes97 views2 answers
Django mysql
SQL
0 vote151 views1 answer
Mysql where in maintain order
SQL
8 votes145 views1 answer
Oracle all_source package body
SQL
1 vote94 views1 answer
Postgres reset auto increment
SQL