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

0 vote135 views2 answers
Nodejs mysql convert to plain object
SQL
0 vote120 views1 answer
Php delete database
SQL
1 vote137 views2 answers
Mysql SELECT
SQL
11 votes138 views2 answers
Sql rank
SQL
0 vote123 views1 answer
Oarcale list objects
SQL
0 vote127 views1 answer
Mysql Selected All Duplicate Rows
SQL
1 vote130 views1 answer
Oracle turn off constraint
SQL
0 vote117 views1 answer
How to to get current date and time in sql
SQL
0 vote112 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
1 vote112 views1 answer
Sql alchemy with azuresql server
SQL