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

0 vote246 views1 answer
Lister les index d'une table oracle
SQL
0 vote261 views1 answer
View to table
SQL
0 vote265 views1 answer
Get db connection detail from sql developer profile
SQL
1 vote267 views1 answer
Delete specific row in sql
SQL
1 vote249 views2 answers
Mysql spring boot application.properties
SQL
0 vote263 views2 answers
Sql drop view if exists
SQL
13 votes277 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote252 views1 answer
Systemverilog unique constraint unique values
SQL
1 vote272 views2 answers
Sql for date greater than
SQL
3 votes251 views1 answer
Sql multiple column index
SQL