/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

31 votes248 views1 answer
Postgresql add column with constraint
SQL
0 vote205 views1 answer
Check if due date is less than todays date sql
SQL
0 vote250 views1 answer
Get number of tables in database sql
SQL
4 votes269 views1 answer
Search column by name mysql
SQL
1 vote256 views1 answer
Sql padd let with zeros
SQL
2 votes254 views1 answer
Oracle sql concatenate results into string
SQL
0 vote272 views1 answer
Mysql uuid
SQL
0 vote250 views1 answer
Add column in sql server ubuntu
SQL
0 vote255 views1 answer
How to find username and password in oracle 18c
SQL
0 vote260 views1 answer
Postgresql remove new line from string
SQL