Oracle index size calculation

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

4 votes326 views3 answers
Drop Table Oracle
SQL
1 vote329 views2 answers
Laravel get sql query eloquent with parameters
SQL
-1 vote367 views1 answer
Add 10 to all numbers in a column sql
SQL
13 votes314 views2 answers
Check if value is null mysql
SQL
-1 vote343 views1 answer
Phinehas Psalm 106
SQL
0 vote306 views1 answer
Python mysql query where
SQL
10 votes310 views3 answers
Insert into auto increment mysql
SQL
0 vote325 views1 answer
Choose only one for each distinct collumn regardless of other columns
SQL
0 vote300 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
-1 vote329 views1 answer
Mysql select all columns and specific fields as
SQL