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 vote373 views1 answer
Android sqlite add column if not exists
SQL
2 votes336 views1 answer
Mysql sysdate
SQL
0 vote361 views2 answers
Cascade syntax in sql
SQL
0 vote380 views1 answer
Oracle query archive mode
SQL
0 vote379 views1 answer
One table with another
SQL
5 votes353 views1 answer
Oracle columns in all_tables
SQL
2 votes362 views1 answer
Sql column values comma separated
SQL
0 vote362 views1 answer
Sql count total by foreign key
SQL
0 vote400 views1 answer
Get primary key of table
SQL
0 vote418 views2 answers
How to truncate all table in mysql workbench
SQL