/SQL/Size of all tables in a schema oracle

Size of all tables in a schema oracle

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 vote245 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
24 votes278 views5 answers
Import dump mysql
SQL
0 vote255 views1 answer
Mysql jdbc timezone
SQL
0 vote269 views1 answer
Mysql default timestamp value to be current timestamp
SQL
1 vote264 views1 answer
Pv mysql import
SQL
0 vote253 views2 answers
Postgresql create role
SQL
0 vote249 views1 answer
Format the money fied with comma in international system using sql
SQL
0 vote221 views1 answer
Get last run query sql server
SQL
1 vote259 views1 answer
Sqlite create index
SQL
6 votes281 views2 answers
Non relational database
SQL