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 vote121 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
4 votes119 views1 answer
Oracle session date format
SQL
0 vote133 views1 answer
Create-table-with-index-organization
SQL
1 vote143 views1 answer
Add multiple row table pl sql
SQL
3 votes141 views1 answer
Oracle revoke
SQL
0 vote122 views1 answer
Declare date variable sql
SQL
0 vote139 views1 answer
Interview experience as a call?
SQL
0 vote126 views2 answers
Csv into data postgres
SQL
0 vote128 views1 answer
Mysql set variable to today's date
SQL
0 vote135 views3 answers
How to run sql query
SQL