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 vote194 views1 answer
Mysql where in keep order
SQL
1 vote161 views1 answer
Strict in postgres SQL
SQL
0 vote196 views1 answer
Sql how to get courses that i have made prerequisites
SQL
1 vote203 views1 answer
Increase existing date in sql
SQL
2 votes217 views1 answer
Column names in oracle sql
SQL
0 vote187 views1 answer
How to count with except in psql
SQL
0 vote186 views1 answer
Update and keep original value sql
SQL
1 vote274 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
0 vote213 views1 answer
Codigo crear tablas sql server
SQL
0 vote202 views1 answer
Search starting with mysql
SQL