/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 vote104 views1 answer
How to switch user in mysql
SQL
14 votes103 views3 answers
Trim sql
SQL
0 vote101 views1 answer
Mysql concat and use as where column
SQL
0 vote133 views2 answers
Sql if empty then
SQL
1 vote111 views3 answers
Epoch to datetime
SQL
16 votes127 views3 answers
Get count of duplicate records
SQL
-1 vote107 views1 answer
Can pandas fetch data from sql
SQL
2 votes105 views2 answers
Mysql user access to database
SQL
0 vote110 views2 answers
Identity syntax in sql
SQL
0 vote110 views1 answer
Show create table in postgresql
SQL