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 vote234 views2 answers
Check if sql temp table exists
SQL
0 vote207 views1 answer
Sql transact create cursor with dynamic tables
SQL
2 votes208 views1 answer
Pandas to sql index
SQL
0 vote210 views1 answer
Sql count total by foreign key
SQL
5 votes207 views3 answers
Truncate function in sql oracle
SQL
0 vote233 views2 answers
Connect to mysql server mac terminal
SQL
0 vote230 views1 answer
Sql convert unix time to date
SQL
0 vote215 views1 answer
Install mysql for fedora 34
SQL
0 vote219 views1 answer
Cross apply top for each row t1
SQL
0 vote211 views1 answer
Postgres drop type
SQL