/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

1 vote246 views1 answer
Mysql size int
SQL
-1 vote239 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
1 vote245 views1 answer
How to delete data from sql database in android
SQL
1 vote236 views1 answer
Sqlite3 read only
SQL
2 votes230 views1 answer
Alter table add multiple columns postgresql
SQL
-1 vote197 views2 answers
Datetime sql server week
SQL
3 votes224 views2 answers
How to View column names of a table in SQL
SQL
0 vote237 views1 answer
Mysql default uuid
SQL
1 vote216 views1 answer
Find logged in users mysql
SQL
17 votes245 views6 answers
MySQL ORDER BY
SQL