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 vote109 views1 answer
Shrink database file in sql server
SQL
0 vote171 views1 answer
Mysql update table from select on another table
SQL
0 vote101 views1 answer
How to define a save method in ruby for sql databases
SQL
1 vote138 views1 answer
Homebrew install mysql
SQL
1 vote110 views1 answer
Mysql sort by date column
SQL
3 votes112 views1 answer
Sql double index
SQL
1 vote109 views1 answer
Find a column in all tables postgres
SQL
0 vote129 views1 answer
Mysql select random rows large table
SQL
0 vote108 views1 answer
Sql revert migration
SQL
14 votes126 views3 answers
Inner join sql oracle
SQL