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

4 votes229 views4 answers
Update select mysql
SQL
12 votes240 views2 answers
Delete all entries postgres
SQL
1 vote254 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
0 vote239 views1 answer
Call scalar valued function sql
SQL
3 votes250 views1 answer
Locate sql server
SQL
2 votes216 views1 answer
Sql find missing values between two tables
SQL
0 vote259 views1 answer
What is delimiter in mysql
SQL
0 vote228 views1 answer
Including parameters in OPENQUERY
SQL
0 vote237 views1 answer
Mssql now diff 90 day
SQL
0 vote242 views2 answers
Create-toys-table-with-toy_name-column
SQL