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

2 votes209 views1 answer
Create mysql user on all hosts
SQL
0 vote198 views1 answer
Oracle sql number to varchar2
SQL
2 votes177 views3 answers
Mysql cheat sheet
SQL
0 vote197 views1 answer
Running query in redshift
SQL
0 vote198 views1 answer
Can't connect to postgresql mac os
SQL
1 vote212 views1 answer
Sql server if exists update else insert
SQL
2 votes195 views1 answer
Change primary key sql
SQL
12 votes199 views6 answers
Between in sql
SQL
4 votes207 views3 answers
Mysql get column names from table
SQL
0 vote187 views1 answer
AddEntityFrameworkSqlite
SQL