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

1 vote196 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
1 vote175 views1 answer
T-sql disable system versioning
SQL
0 vote149 views1 answer
Mql5 list all available symbols
SQL
123 votes285 views5 answers
Sql where contains
SQL
0 vote158 views1 answer
Delete data from database sqlite android
SQL
0 vote169 views1 answer
Sql grant select only
SQL
1 vote178 views1 answer
Pagination sql
SQL
1 vote195 views1 answer
Oracle see column type
SQL
2 votes179 views1 answer
Mariadb JSON_EXTRACT
SQL
0 vote177 views1 answer
MySQL update with subquery
SQL