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 vote271 views1 answer
Unique vs distinct sql
SQL
0 vote319 views1 answer
Connect postgresql using a connection string
SQL
6 votes326 views2 answers
Sql query to get the number of rows in a table
SQL
0 vote335 views1 answer
Postgresql create query
SQL
29 votes328 views5 answers
Mysql show table structure
SQL
0 vote359 views1 answer
Sql pivot without aggregate
SQL
0 vote314 views1 answer
Mysql server not running
SQL
0 vote345 views1 answer
Sql date time query find
SQL
3 votes345 views1 answer
Postgresql today - 1 year
SQL
0 vote310 views1 answer
2020 new year
SQL