/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 vote133 views1 answer
How to connect postgresql database with java
SQL
0 vote139 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
-1 vote129 views3 answers
Mysql get age from date
SQL
0 vote188 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
4 votes158 views2 answers
DB::transaction
SQL
0 vote149 views1 answer
Sql select where more than one record exists
SQL
0 vote162 views1 answer
Repeatable read trong sql server
SQL
3 votes140 views2 answers
Mysql create timestamp column
SQL
0 vote138 views1 answer
How to use group_concat in sql server
SQL
2 votes128 views1 answer
Oracle create directory
SQL