/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

4 votes295 views1 answer
Oracle error line
SQL
0 vote274 views1 answer
Get employees if not contains in sql
SQL
0 vote304 views1 answer
How to generate ids in sql
SQL
3 votes290 views2 answers
Enter mysql command line
SQL
0 vote285 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
1 vote276 views1 answer
Create temporal table in sql
SQL
11 votes303 views3 answers
How to get last row of table in sql
SQL
3 votes288 views1 answer
Oracle show trigger code
SQL
0 vote333 views1 answer
Mariadb.service failed with result 'exit-code'
SQL
7 votes276 views1 answer
Postgres base size
SQL