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

0 vote353 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
0 vote343 views1 answer
Replace content value from old to new sql
SQL
3 votes407 views1 answer
Mysql cli connect with password
SQL
0 vote393 views1 answer
Sql show founctions
SQL
0 vote329 views1 answer
Sqlalchemy case insensitive like
SQL
26 votes345 views2 answers
Mysql workbench download
SQL
0 vote375 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL
0 vote342 views1 answer
ORA-00942
SQL
0 vote321 views1 answer
Sql get table last modified time
SQL
0 vote361 views1 answer
Select top values sql
SQL