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 vote197 views1 answer
Mysql history command
SQL
0 vote154 views1 answer
Check if due date is less than todays date sql
SQL
11 votes213 views5 answers
How to install sqlite3 python
SQL
1 vote193 views1 answer
How to get alternate records from a table in sql
SQL
0 vote199 views1 answer
SQL Server format datetime
SQL
3 votes189 views1 answer
Oracle function
SQL
16 votes224 views2 answers
Mysql date between two dates
SQL
10 votes200 views1 answer
Oracle dba_dependencies
SQL
0 vote310 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
0 vote212 views1 answer
Microsoft sql server python connection
SQL