Oracle 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 vote138 views1 answer
Select new table sql
SQL
2 votes113 views1 answer
Oracle create directory
SQL
6 votes111 views4 answers
Eloquent to sql with bindings
SQL
0 vote124 views1 answer
Sql select non unique
SQL
0 vote136 views2 answers
Enter into postgresql database,create user and grant Access
SQL
0 vote121 views1 answer
Mysql select all table that have field names
SQL
0 vote149 views1 answer
Select all same column value in sql
SQL
1 vote128 views2 answers
How to check if sql query is correct online
SQL
8 votes137 views10 answers
Sql
SQL
2 votes124 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL