Oracle 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 vote160 views1 answer
View psql output in horizontal scrolling
SQL
1 vote198 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
0 vote156 views1 answer
Sql show founctions
SQL
0 vote144 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL
0 vote104 views1 answer
Get all stored procedures in sql server
SQL
0 vote150 views1 answer
Alter table engine mysql
SQL
2 votes150 views1 answer
Q operator in plsql
SQL
1 vote186 views1 answer
Set statiscis on in sql server
SQL
3 votes134 views3 answers
Concatenation in sql
SQL
0 vote150 views1 answer
Sql max min
SQL