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 vote210 views1 answer
Select 1 from orders
SQL
8 votes172 views2 answers
Mysql grant all privileges to user from any host
SQL
2 votes187 views1 answer
Sql find not in list
SQL
0 vote179 views1 answer
How to join result table in mysql
SQL
16 votes168 views1 answer
CTE statement sql server
SQL
1 vote168 views1 answer
Oracle case
SQL
0 vote174 views1 answer
Get who is hired in january in sql
SQL
1 vote182 views2 answers
Postgresql check privileges on schema
SQL
13 votes177 views4 answers
What is sql
SQL
0 vote169 views1 answer
Display first three characters sql
SQL