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 vote150 views2 answers
Select index table oracle
SQL
5 votes150 views2 answers
Sql server port number
SQL
14 votes159 views3 answers
How to add default constraint in mysql
SQL
0 vote156 views1 answer
How get data from database if id not found then search another column
SQL
11 votes160 views1 answer
Ddl view
SQL
1 vote158 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
8 votes135 views1 answer
How to remove tables from postgresql
SQL
1 vote231 views1 answer
Adding a check statement in sql
SQL
11 votes230 views2 answers
Sql between date range
SQL
0 vote165 views1 answer
Soql last week
SQL