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

24 votes266 views4 answers
Delete db postgres
SQL
0 vote239 views1 answer
Remove from table where
SQL
16 votes257 views6 answers
Mysql find and replace
SQL
2 votes240 views1 answer
Sql select min value from multiple columns
SQL
0 vote259 views1 answer
Join creating duplicate columns sqllite
SQL
0 vote259 views1 answer
Sql server remove primary key without dropping table
SQL
0 vote264 views3 answers
Remove folders from remote git
SQL
0 vote262 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
0 vote259 views1 answer
How to add more columns to a table in mysql
SQL
16 votes267 views3 answers
Jwt secret key generator laravel
SQL