/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 vote146 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
2 votes145 views1 answer
Sql server current date minus 5 years
SQL
0 vote126 views1 answer
Data directory postgresql
SQL
0 vote135 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
20 votes144 views3 answers
How to open postgresql in mac
SQL
3 votes156 views3 answers
Start postgresql ubuntu
SQL
6 votes209 views2 answers
Database url postgres
SQL
0 vote133 views1 answer
Generate sequence number in sql server
SQL
15 votes144 views3 answers
Create table with primary key auto increment in sql
SQL
-1 vote117 views3 answers
Mysql get age from date
SQL