/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 vote122 views2 answers
Wordpress change url in database
SQL
1 vote127 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
0 vote123 views1 answer
Psql generate id in existing database
SQL
1 vote137 views1 answer
UseSqlServer no definition
SQL
1 vote115 views1 answer
Spark sql concatenate string and int
SQL
0 vote105 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
3 votes143 views1 answer
Oracle nextval insert
SQL
8 votes124 views1 answer
Oracle find text in functions
SQL
3 votes128 views2 answers
Update part of a string in mysql
SQL
5 votes128 views2 answers
Postgres update with if condition query
SQL