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 votes238 views3 answers
Postgres database sizes
SQL
8 votes200 views1 answer
Mysql restore database
SQL
0 vote210 views1 answer
What is common table expression in sql
SQL
22 votes180 views4 answers
Mysql date_format
SQL
1 vote179 views1 answer
Convert rows to string sql server
SQL
0 vote182 views1 answer
Group by join columns per table
SQL
0 vote188 views1 answer
Select * from mysql.proc
SQL
11 votes187 views3 answers
How to get last row of table in sql
SQL
0 vote185 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
0 vote223 views1 answer
Plsql check for string in numeric
SQL