/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 vote355 views1 answer
Mysql date minus 1 day
SQL
18 votes299 views2 answers
How to get all the tables displayed in oracle
SQL
0 vote383 views1 answer
Hou to run job from cmd .exe sql server jop
SQL
0 vote350 views1 answer
Restart sql server command line linux
SQL
0 vote348 views1 answer
Which MySQL data type to use for storing boolean values
SQL
20 votes342 views2 answers
Mysql bigint max value
SQL
6 votes355 views4 answers
Delete table sqlite
SQL
0 vote370 views1 answer
How to declare variable date in mysql
SQL
0 vote338 views1 answer
Order by monthly in sql
SQL
2 votes372 views1 answer
Ifnull postgres
SQL