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 vote154 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
0 vote149 views1 answer
Download sql file of countries names
SQL
0 vote140 views1 answer
Opensuse status MySQL
SQL
0 vote155 views1 answer
Convert polygon to text in mysql
SQL
4 votes182 views1 answer
Mysql delete last row
SQL
0 vote138 views1 answer
C# add a textbox in mysql select
SQL
13 votes140 views2 answers
Sqlite rename column
SQL
0 vote144 views1 answer
Mysql milliseconds
SQL
2 votes165 views3 answers
Row number mssql
SQL
1 vote140 views1 answer
GROUP BY clause; this is incompati
SQL