/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 vote238 views1 answer
Spring boot mysql connection properties
SQL
3 votes235 views2 answers
Oracle sql select all days between two dates except weekends
SQL
16 votes224 views6 answers
Mysql find and replace
SQL
0 vote227 views1 answer
Call procedure in wordpress
SQL
3 votes261 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL
0 vote236 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
0 vote220 views1 answer
Sql select most frequent value in group
SQL
0 vote233 views1 answer
Best sql collation
SQL
16 votes235 views1 answer
Mysql smallint range
SQL
3 votes248 views2 answers
How to force truncate a table in mysql
SQL