/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 vote288 views2 answers
Sql example query
SQL
12 votes322 views5 answers
Rename table in mysql
SQL
3 votes313 views1 answer
Increment integer in table sql
SQL
1 vote305 views1 answer
Postgresql round double precision
SQL
5 votes294 views1 answer
Purge undo tablespace oracle 11g
SQL
0 vote288 views1 answer
Create sql table from script inline primary key constraint
SQL
0 vote324 views1 answer
Check database restore status sql script
SQL
0 vote274 views2 answers
Sql query unique
SQL
18 votes251 views2 answers
How to get all the tables displayed in oracle
SQL
1 vote305 views1 answer
How to ckeck that email is present in databse in mysqli
SQL