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

1 vote206 views1 answer
Increasing font and zooming in mysql workbench
SQL
0 vote181 views1 answer
List column names of multiple tables psql
SQL
0 vote188 views1 answer
Sql select column names starting with
SQL
4 votes203 views3 answers
Rename table column postgresql
SQL
0 vote183 views1 answer
Opensuse status MySQL
SQL
2 votes193 views1 answer
Add default sql server
SQL
0 vote181 views1 answer
How to select all fieldsin a soql query
SQL
6 votes193 views2 answers
Oracle trigger
SQL
0 vote185 views1 answer
Mysql two joins
SQL
22 votes232 views1 answer
Mysql workbench
SQL