/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
Sql datum formatieren
SQL
0 vote118 views1 answer
Update sqlite
SQL
0 vote110 views1 answer
Hibernate with springboot mysql
SQL
0 vote100 views1 answer
Mysql case when null
SQL
0 vote118 views1 answer
HOW to select specific table data from an mysql databse server:
SQL
0 vote101 views1 answer
Declare date variable sql
SQL
5 votes113 views1 answer
AND OR NOT operators sql
SQL
0 vote112 views1 answer
Sub query in linq
SQL
1 vote131 views1 answer
Count of tables in database mysql
SQL
-1 vote130 views1 answer
Get month and year from date in mysql sequelize
SQL