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 vote155 views1 answer
Md5 encryption for existing records
SQL
0 vote141 views1 answer
Drop all tables in azure sql database
SQL
0 vote177 views1 answer
Oracle insert single quote in string
SQL
3 votes207 views1 answer
Query less than datetime sql
SQL
0 vote117 views1 answer
Flask_sqlalchemy install
SQL
22 votes265 views4 answers
Tsql rename table
SQL
1 vote148 views2 answers
How to check username in mysql command line
SQL
0 vote153 views1 answer
Number(10 2) in sql means
SQL
0 vote153 views1 answer
Sql select lowest value row
SQL
0 vote166 views3 answers
Postgres date difference seconds
SQL