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

3 votes106 views2 answers
To_char sql
SQL
7 votes126 views2 answers
Oracle sql drop index
SQL
0 vote115 views1 answer
Optimize sql query
SQL
0 vote84 views1 answer
Mysql offset from bottom
SQL
0 vote117 views1 answer
Get only one row in mysql
SQL
0 vote109 views1 answer
VSCode SQL Server Connection error
SQL
0 vote127 views1 answer
Insert using condition postgres
SQL
0 vote105 views1 answer
Sql get month and year from date
SQL
0 vote135 views1 answer
Mysql get only the field names in a table
SQL
15 votes118 views4 answers
How to get all tables in sql
SQL