Oracle index size

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 vote226 views2 answers
How to search date in sql query
SQL
13 votes218 views6 answers
Restart postgresql
SQL
0 vote207 views1 answer
Find largest table in mysql database
SQL
0 vote219 views2 answers
Sql update multiple tables
SQL
13 votes229 views6 answers
Mysql remove duplicates
SQL
0 vote197 views2 answers
Avg() sql
SQL
2 votes220 views1 answer
Query any digits record
SQL
0 vote169 views1 answer
Expose db in virtualbox
SQL
12 votes224 views1 answer
Script to add new column in table sql
SQL
0 vote209 views1 answer
Sql auto_increment syntax
SQL