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 vote217 views1 answer
Selects all the columns from the sailors table
SQL
0 vote241 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
0 vote236 views1 answer
Cross apply top for each row t1
SQL
4 votes252 views2 answers
Mysql alter table set column unique
SQL
0 vote240 views1 answer
How to move a column to different spot mysql
SQL
0 vote245 views4 answers
Postgresql between month
SQL
51 votes377 views6 answers
Opera gx
SQL
-1 vote253 views1 answer
Create view in mysql workbench
SQL
4 votes301 views2 answers
Sql display today's date
SQL
10 votes277 views6 answers
Mysql set root password
SQL