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

13 votes180 views3 answers
Change data type postgresql
SQL
0 vote212 views1 answer
How to subquey to do not load in live database in
SQL
0 vote185 views1 answer
How to find database collation in postgres
SQL
0 vote162 views1 answer
Sql clear table
SQL
0 vote175 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
0 vote182 views1 answer
Pagination with row_number
SQL
1 vote169 views3 answers
Mysql Server Start
SQL
0 vote207 views1 answer
Mariadb.service failed with result 'exit-code'
SQL
1 vote211 views1 answer
Sql sort column by date
SQL
1 vote176 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL