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 vote158 views1 answer
Insert or update sql firebird
SQL
0 vote139 views1 answer
Inner joint
SQL
0 vote144 views1 answer
Set a default value for a column in sqlite
SQL
21 votes192 views6 answers
Update sql
SQL
0 vote155 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
0 vote147 views1 answer
Oracle drop type
SQL
0 vote159 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
1 vote138 views1 answer
Moodle query item quiz
SQL
-1 vote214 views5 answers
Left join
SQL
0 vote144 views1 answer
Typeorm raw sql
SQL