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

-1 vote107 views3 answers
Mysql get age from date
SQL
0 vote123 views1 answer
Mysql backup certain tables workbench
SQL
2 votes114 views2 answers
Mysql user access to database
SQL
4 votes114 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
7 votes83 views1 answer
Mysql load data infile csv
SQL
4 votes114 views2 answers
Tsql utf to local time
SQL
0 vote122 views1 answer
Sql remove last 2 digit
SQL
2 votes127 views2 answers
Mysql limit
SQL
5 votes121 views2 answers
Oracle find all tables with column name
SQL
1 vote108 views1 answer
Influxdb export to csv
SQL