DBA Hub

📋Steps in this guide1/1

Top index sizes of table/schema

--- Find index name and their sizes of a table

oracle configurationintermediate
by OracleDba
11 views
1

Top index sizes of table/schema

--- Find index name and their sizes of a table -- Find total_index_size of respective tables in a schema

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
SELECT idx.table_name,bytes/1024/1024/1024
FROM dba_segments seg,
dba_indexes idx
where idx.table_name='&TABLE_NAME'
AND idx.index_name = seg.segment_name
GROUP BY idx.table_name order by 1;
SELECT idx.table_name, SUM(bytes/1024/1024/1024)
FROM dba_segments seg,
dba_indexes idx
WHERE idx.table_owner = 'SIEBEL'
AND idx.owner = seg.owner
AND idx.index_name = seg.segment_name
GROUP BY idx.table_name order by 1

Comments (0)

Please to add comments

No comments yet. Be the first to comment!