/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

3 votes110 views2 answers
Coalesce mysql
SQL
4 votes170 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
0 vote145 views1 answer
Codeigniter dbforge add index
SQL
0 vote187 views1 answer
How to connect to xampp sql server on windows cmd
SQL
3 votes207 views1 answer
Mysql group_concat distinct
SQL
0 vote151 views1 answer
Select * from mysql.proc
SQL
1 vote230 views1 answer
Alter constraint postgres
SQL
0 vote136 views1 answer
Mysql update sum same table
SQL
1 vote161 views1 answer
Postgresql not in
SQL
3 votes138 views3 answers
Create a view postgres
SQL