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

3 votes130 views1 answer
Two select sql
SQL
0 vote128 views1 answer
How to select only a certain date sql
SQL
0 vote138 views1 answer
Oracle c# multiple update sql
SQL
11 votes129 views2 answers
Mysql set safe mode off
SQL
1 vote124 views1 answer
Oracle check table space
SQL
2 votes158 views2 answers
Postgres set user as superuser
SQL
0 vote140 views1 answer
Mysql check if lowercase
SQL
0 vote92 views1 answer
Import csv to mysql
SQL
0 vote127 views1 answer
Copy Table from SQL to CSV
SQL
1 vote133 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL