/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 vote332 views1 answer
Oracle create as select
SQL
0 vote345 views1 answer
Oracle sql number to varchar2
SQL
1 vote320 views2 answers
Mysql current user
SQL
5 votes311 views1 answer
How to check nls timestamp format in oracle
SQL
0 vote317 views1 answer
Dns slave zone convert
SQL
15 votes325 views3 answers
Find duplicate keys in mysql
SQL
0 vote337 views1 answer
Mysql shell ERROR: Not connected.
SQL
0 vote350 views1 answer
Mysql trigger to delete old data
SQL
24 votes335 views6 answers
Rename a column in sql server
SQL
0 vote292 views1 answer
Print sum of values sql
SQL