/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

3 votes336 views2 answers
Install mysql powershell
SQL
0 vote334 views1 answer
Hoq to import database source
SQL
9 votes311 views4 answers
Add primary key to existing table sql
SQL
0 vote329 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
16 votes335 views4 answers
Ascending order mysql
SQL
1 vote351 views1 answer
Mysql previous year
SQL
0 vote315 views1 answer
Sql create table with references not primary key
SQL
1 vote326 views1 answer
Sql how to duplicate a table
SQL
6 votes330 views3 answers
Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mydb.term.year' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
8 votes321 views1 answer
Oracle all_source package body
SQL