/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

0 vote191 views1 answer
How to update sql server version
SQL
1 vote184 views1 answer
Oracle apex prevent initial load
SQL
0 vote232 views1 answer
Postgresql alter table sequence
SQL
1 vote211 views1 answer
Increase existing date in sql oracle
SQL
0 vote176 views1 answer
Mysql isshow
SQL
0 vote177 views1 answer
Get number of rows in every table mysql
SQL
0 vote205 views1 answer
How to define a non primary composite key in sql
SQL
-1 vote187 views1 answer
Can pandas fetch data from sql
SQL
19 votes189 views5 answers
Change column name mysql command line
SQL
13 votes267 views3 answers
Sql select from multiple tables without join
SQL