/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

1 vote180 views1 answer
Pgsql sum switch case
SQL
16 votes159 views5 answers
Select last row in sql
SQL
0 vote138 views1 answer
Sql select with apostrohpe
SQL
17 votes163 views1 answer
Selecting name that contain certain word in sql
SQL
1 vote140 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
1 vote128 views1 answer
Oracle explain plan
SQL
0 vote159 views1 answer
Get created time of database psql 8
SQL
0 vote123 views1 answer
Sql trim whitespace
SQL
9 votes142 views4 answers
How to alter table column name in mysql
SQL
0 vote246 views1 answer
Multiple replace value mssql
SQL