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 vote139 views1 answer
How to insert multiple rows in mysql using laravel
SQL
0 vote147 views2 answers
How to type a blank discord messgae
SQL
7 votes144 views2 answers
Create mysql user
SQL
0 vote174 views1 answer
Count column of tables psql
SQL
0 vote130 views1 answer
What is between operator
SQL
1 vote137 views1 answer
Search for replace in mysql
SQL
0 vote129 views2 answers
Remove mysql workbench ubuntu
SQL
0 vote126 views1 answer
Import big data to mysql
SQL
2 votes128 views1 answer
Plsql block
SQL
8 votes144 views1 answer
Mysql limit rows
SQL