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

53 votes321 views6 answers
How to install mysql ubuntu
SQL
0 vote199 views1 answer
DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER
SQL
0 vote203 views2 answers
Temp Space
SQL
14 votes202 views1 answer
Oracle alter table add column not null
SQL
0 vote175 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
0 vote163 views1 answer
How to to get current date and time in sql
SQL
0 vote186 views1 answer
Get sum sqlite android
SQL
1 vote198 views1 answer
Mysql text to decimal
SQL
1 vote188 views1 answer
Get parameter value in mysql trigger
SQL
7 votes175 views3 answers
Postgre describe table
SQL