/SQL/Size of all tables in a schema oracle

Size of all tables in a schema oracle

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 vote271 views1 answer
Mysql jdbc timezone
SQL
0 vote306 views1 answer
Check database restore status sql script
SQL
0 vote259 views1 answer
Drop all data from tables
SQL
15 votes295 views3 answers
Postgresql change column type
SQL
1 vote293 views3 answers
Epoch to datetime
SQL
49 votes325 views6 answers
Get duplicate records in sql
SQL
0 vote296 views1 answer
How to make case insensitive in sql
SQL
3 votes289 views3 answers
Restart mysql mac
SQL
3 votes259 views1 answer
Difference sql vs mysql
SQL
2 votes305 views1 answer
Oracle insert or update
SQL