/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 vote316 views1 answer
Ms sql filter all sympbol
SQL
5 votes308 views1 answer
Postgresql functions
SQL
1 vote297 views1 answer
How much every mysql database record takes from diskspace
SQL
0 vote272 views1 answer
Mysql does collate nopad recognize space
SQL
2 votes350 views1 answer
Python sql
SQL
0 vote314 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
0 vote325 views1 answer
ACCEPT nome PROMPT on oracle
SQL
0 vote303 views1 answer
Php delete database
SQL
0 vote314 views1 answer
Oracle service name view
SQL
2 votes324 views2 answers
Convert_tz mysql
SQL