Oracle index size calculation

SELECT SEGMENT_NAME, OWNER, round(sum(BYTES) / 1e6, 0) AS SIZE_MB
FROM DBA_SEGMENTS
WHERE TABLESPACE_NAME = 'tbs_name'
GROUP BY SEGMENT_NAME, OWNER
ORDER BY SIZE_MB DESC;

Similar codes

0 vote135 views1 answer
Oracle sql developer script output limit
SQL
1 vote190 views2 answers
How to drop a unique constraint in sql
SQL
11 votes242 views2 answers
Docker create postgres db
SQL
0 vote169 views1 answer
Get only first row mysql
SQL
0 vote175 views1 answer
Postgres create database if not exists
SQL
0 vote182 views1 answer
Get all employee of salary if more than in sql
SQL
0 vote201 views1 answer
Sql sum show 0 result
SQL
3 votes187 views1 answer
Mysql set field unique
SQL
0 vote216 views1 answer
Database db connection string format
SQL
0 vote187 views1 answer
How to fetch unique records from two tables
SQL