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 vote123 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
3 votes86 views1 answer
Ubuntu install postgresql 12
SQL
0 vote132 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
13 votes124 views2 answers
Sqlite rename column
SQL
0 vote142 views1 answer
Mysql root localhost run
SQL
8 votes153 views1 answer
Insert a select statement into a table
SQL
0 vote118 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
3 votes123 views1 answer
Oracle list dates without weekends
SQL
10 votes132 views2 answers
Show tables in schema oracle
SQL
4 votes148 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL