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

1 vote191 views1 answer
Cannot drop database because it is currently in use
SQL
0 vote160 views1 answer
Sql requete number pair
SQL
0 vote177 views4 answers
How to get max salary in each department in sql
SQL
1 vote169 views2 answers
End mysql command
SQL
25 votes178 views6 answers
How to change column name in mysql
SQL
1 vote161 views1 answer
Sql oracle update multiple rows
SQL
0 vote184 views1 answer
How to check database engine in mysql
SQL
0 vote171 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
0 vote172 views1 answer
Set classpath for mysql-connector.jar
SQL
0 vote192 views1 answer
Postgresql like
SQL