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

8 votes205 views1 answer
Oracle search code in packages
SQL
3 votes136 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
0 vote138 views1 answer
How to select a row in sql
SQL
0 vote151 views1 answer
Sql server current time without date
SQL
0 vote144 views1 answer
How to change mysql root password in windows 10
SQL
0 vote138 views3 answers
Sql select statements
SQL
1 vote154 views1 answer
Postgresql not in
SQL
0 vote134 views1 answer
Mysql database hyphen
SQL
0 vote139 views1 answer
Influxdb clone measurement
SQL
0 vote133 views1 answer
Forcefully delete a row in mysql which has references
SQL