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 vote275 views2 answers
Mysql multiply
SQL
7 votes295 views2 answers
Html to react converter
SQL
0 vote353 views1 answer
Plpgsql create function
SQL
1 vote292 views2 answers
Copy database mysql
SQL
0 vote231 views2 answers
Jupyter notebook connect to database
SQL
0 vote287 views2 answers
Postgres another version
SQL
0 vote292 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
4 votes290 views2 answers
Postgres update single column
SQL
0 vote273 views1 answer
Pl/sql loop example
SQL
0 vote314 views1 answer
Firebase sql
SQL