Orcale 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

1 vote191 views1 answer
Count mysql server db tables
SQL
1 vote174 views1 answer
Importance of comment in mysql
SQL
15 votes210 views5 answers
Select all tables sql
SQL
6 votes181 views1 answer
Oracle list primary key
SQL
2 votes170 views1 answer
Oracle create directory
SQL
0 vote212 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
0 vote222 views1 answer
Mssql last day of month
SQL
0 vote216 views1 answer
Database db connection string format
SQL
0 vote180 views1 answer
Mysql 5.7 in centos 7
SQL
1 vote211 views1 answer
Oracle index partition
SQL