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 vote275 views1 answer
Jooq finding lastest value in table
SQL
0 vote332 views2 answers
Add colum in sql
SQL
3 votes322 views1 answer
Null sql
SQL
2 votes350 views3 answers
Postgres json to string
SQL
0 vote320 views1 answer
Oracle temporary table
SQL
0 vote336 views4 answers
Convert databse to achieve log mode oracle
SQL
0 vote347 views1 answer
Local pg_sql to heroku pg_sql
SQL
10 votes309 views1 answer
Query to find object dependencies in oracle
SQL
1 vote354 views1 answer
Oracle create program if not exists
SQL
0 vote312 views1 answer
Mysql change timestamp on update
SQL