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

3 votes136 views1 answer
Sql insert inserted id
SQL
2 votes137 views1 answer
Add default sql server
SQL
1 vote138 views1 answer
Postgres count string length
SQL
5 votes89 views1 answer
Postgres upsert
SQL
3 votes131 views2 answers
Mysql time
SQL
1 vote120 views1 answer
Mysql count all table rows
SQL
2 votes125 views2 answers
Spring import sql
SQL
2 votes148 views1 answer
Oracle trace file
SQL
0 vote141 views1 answer
Mysql 8 error on identified by
SQL
3 votes142 views1 answer
Oracle get trigger ddl
SQL