/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 vote330 views1 answer
How to drop columns with constraint from a table in sql script
SQL
0 vote453 views1 answer
Trigger
SQL
1 vote375 views3 answers
Sql server get week dates from week number
SQL
1 vote368 views1 answer
Oracle select first result
SQL
0 vote348 views1 answer
Psql not found windows
SQL
0 vote358 views1 answer
Tsql find procedure with name
SQL
1 vote349 views1 answer
Sqlite3 read only
SQL
0 vote358 views1 answer
Mysql read row
SQL
0 vote380 views1 answer
Best way to bind parameters to SqlCommand C#
SQL
2 votes346 views1 answer
Alter table add multiple columns postgresql
SQL