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 vote96 views1 answer
Cross schema query oracle 2 users
SQL
1 vote106 views1 answer
Mysql show database size in mb
SQL
0 vote108 views1 answer
Limit and offset in stored procedure mssql
SQL
1 vote113 views1 answer
How to use db.execute
SQL
0 vote99 views1 answer
First mysql
SQL
4 votes191 views4 answers
Update select mysql
SQL
7 votes100 views2 answers
Phpmyadmin change password
SQL
31 votes111 views4 answers
Mysql grant execute
SQL
0 vote111 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
0 vote109 views1 answer
Get date ISO in psql
SQL