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

1 vote113 views1 answer
Date_part mysql
SQL
12 votes115 views6 answers
Between in sql
SQL
1 vote59 views1 answer
Ms sql how to see active job current run time
SQL
0 vote108 views1 answer
Systemverilog unique constraint unique values
SQL
0 vote118 views1 answer
WHERE not regex in SQL
SQL
0 vote107 views1 answer
Mysql grant grant option
SQL
0 vote106 views1 answer
Eliminar ultimo carcacter mysql
SQL
1 vote101 views1 answer
Create another table from existing table sql oracle
SQL
1 vote113 views1 answer
How to get alternate records from a table in sql
SQL
6 votes126 views2 answers
Mysql timestamp to date
SQL