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

1 vote131 views1 answer
Denied
SQL
0 vote158 views2 answers
Mysql insert into multiple tables
SQL
0 vote187 views1 answer
How to check rollback status in oracle
SQL
9 votes147 views4 answers
Postgresql export database
SQL
0 vote163 views3 answers
Sql parenthetical expression examples
SQL
0 vote171 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
49 votes216 views6 answers
Get duplicate records in sql
SQL
0 vote157 views1 answer
Zsh: command not found: mysql mamp
SQL
1 vote142 views2 answers
Postgresql get difference in hours between two dates
SQL
0 vote159 views1 answer
Alter column to not null with default value sql server
SQL