/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

9 votes338 views4 answers
Mysql set id auto increment
SQL
16 votes328 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
0 vote324 views1 answer
Drop specific row postgresql
SQL
11 votes323 views1 answer
Oracle insert into where
SQL
0 vote312 views1 answer
Python mysqlclient library not found for -lssl
SQL
0 vote323 views1 answer
Creation d'un trigger sql
SQL
2 votes316 views1 answer
How to check grants on a package in oracle
SQL
0 vote320 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
0 vote306 views1 answer
How to print records of employees hired in particular month in oracle
SQL
2 votes309 views1 answer
Sql create database
SQL