/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

58 votes309 views6 answers
Create new user in postgres
SQL
0 vote140 views1 answer
Query string starts with vowels
SQL
1 vote158 views1 answer
Sql server if exists update else insert
SQL
2 votes128 views1 answer
Date_format for time sql
SQL
1 vote137 views1 answer
Oracle create as select
SQL
13 votes130 views5 answers
Oracle list tables
SQL
0 vote112 views1 answer
Separator mysql
SQL
4 votes125 views1 answer
Select nls_date_format
SQL
0 vote99 views1 answer
Raven ql select count
SQL
1 vote92 views1 answer
Database run
SQL