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

0 vote405 views1 answer
Oracle show grants on table
SQL
0 vote349 views1 answer
Search In the Data using ObjectName
SQL
0 vote372 views1 answer
Sql tablo hangi sp de
SQL
-1 vote397 views3 answers
PS5
SQL
1 vote347 views1 answer
Convert rows to string sql server
SQL
1 vote347 views1 answer
Show table columns
SQL
6 votes371 views1 answer
Sql insert values into table
SQL
0 vote355 views1 answer
Multiple tricky query in sql server
SQL
1 vote386 views2 answers
Mysql trim spaces
SQL
0 vote385 views1 answer
Timestamp(0) postgresql
SQL