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 vote347 views1 answer
Sql query interview questions githu
SQL
0 vote360 views1 answer
Sql replace id with name from another table
SQL
0 vote414 views2 answers
How to check if a column exists in a SQL Server table?
SQL
12 votes390 views6 answers
How to install sqlite3 in python
SQL
2 votes399 views1 answer
Show max_allowed_packet mysql
SQL
0 vote348 views1 answer
Sql grant select only
SQL
0 vote362 views1 answer
Mysql multiple primary keys
SQL
0 vote347 views1 answer
Sql server bool select
SQL
0 vote353 views1 answer
How convert into in in sql query
SQL
0 vote337 views1 answer
Mysql select row with min date
SQL