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

-2 votes226 views1 answer
Mysql see users and passwords
SQL
2 votes225 views1 answer
Mysql find tables with name
SQL
0 vote256 views2 answers
Oracle chain rules
SQL
0 vote216 views1 answer
On update current_timestamp jpa
SQL
0 vote245 views1 answer
Sqlite insert or update
SQL
2 votes227 views1 answer
Sql ends with string
SQL
3 votes236 views3 answers
Start postgresql ubuntu
SQL
0 vote219 views1 answer
Sql server current time without date
SQL
1 vote226 views1 answer
Postgres set column based on another column
SQL
0 vote216 views1 answer
Raiserror nowait sql server
SQL