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

0 vote345 views1 answer
Replace divide by zero error with 0 in sql
SQL
5 votes317 views2 answers
Update all rows mysql
SQL
0 vote324 views1 answer
Mysql select where field like in list
SQL
1 vote271 views1 answer
Unique vs distinct sql
SQL
2 votes359 views2 answers
Sqlalchemy return id after insert
SQL
1 vote314 views1 answer
Type int in mysql maxlenght
SQL
1 vote337 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
0 vote355 views1 answer
Influxdb list all tags for a measurement
SQL
0 vote345 views1 answer
Mysql trigger to delete old data
SQL
0 vote347 views1 answer
Sql get year from datetime field
SQL