/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 vote133 views1 answer
Avg mysql
SQL
3 votes99 views1 answer
How to get list of synonyms in oracle
SQL
4 votes147 views2 answers
How to count items with same name in sql
SQL
8 votes155 views2 answers
Alert table name mysql
SQL
-1 vote189 views1 answer
MYSQL stored procedure select from
SQL
2 votes103 views2 answers
Mysql get last character of string
SQL
3 votes152 views1 answer
How to find names includes in sql
SQL
1 vote147 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL
0 vote156 views1 answer
Rename view mysql
SQL
0 vote172 views1 answer
Mysql insert into select transaction c#
SQL