Orcale index size

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 vote270 views1 answer
Write sql query to show the details start from digit
SQL
0 vote270 views1 answer
Postgress append string in select
SQL
1 vote281 views7 answers
Filter
SQL
0 vote292 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
4 votes265 views1 answer
Postgresql change default value
SQL
0 vote291 views1 answer
How to update date value in sql
SQL
0 vote269 views1 answer
Syntax for changing column size in mysql
SQL
0 vote260 views1 answer
How to change the field size of an existing column
SQL
0 vote325 views1 answer
Sql query to select even numbers
SQL
0 vote271 views1 answer
Insert array into mysql column
SQL