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 vote375 views1 answer
Mysql curdate between two dates
SQL
1 vote333 views2 answers
Mysql does sentance contain word
SQL
4 votes348 views1 answer
Oracle table statistics last analyzed
SQL
8 votes359 views3 answers
Postgresql connection string c#
SQL
0 vote337 views1 answer
Backup a table in sql
SQL
1 vote363 views1 answer
Drop column if exists sql server
SQL
0 vote337 views1 answer
The local psql command could not be located
SQL
0 vote407 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
0 vote327 views0 answer
SQL
0 vote357 views1 answer
Oracle procedure chain step
SQL