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

1 vote286 views1 answer
How to update date add hours in postgresql
SQL
0 vote284 views1 answer
Retornar apenas o ano mysql date
SQL
0 vote309 views2 answers
How to count codition
SQL
0 vote291 views1 answer
USING THE NOT CONDITION IN SQL
SQL
0 vote270 views1 answer
Mysql export data with a where clause
SQL
0 vote271 views1 answer
Time mysql w3
SQL
-1 vote276 views3 answers
Check table exist postgresql
SQL
2 votes302 views1 answer
Flask sqlalchemy boolean field
SQL
1 vote277 views1 answer
Substr sql last character
SQL
0 vote241 views1 answer
How to check oracle index table
SQL