Oracle schema size

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 vote254 views1 answer
Nueva tabla mysql
SQL
0 vote268 views1 answer
Connect laravel to mysql on mac
SQL
-1 vote248 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
0 vote283 views1 answer
Date datatype in livesql
SQL
14 votes283 views6 answers
Auto_increment mysql
SQL
0 vote294 views1 answer
Check if mysql db is used
SQL
1 vote268 views2 answers
Last working day in week date function in sql
SQL
1 vote246 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
1 vote290 views1 answer
Postgresql where datetrunc month and year equal
SQL
3 votes251 views2 answers
Oracle for loop
SQL