Explain Unbalanced Index in Oracle?

Answer 1

if we do have lot on index on a table and we are doing I/U/D frequently then there is a problem of disk contention . To check this problem sees the BLEVEL value in DBA_INDEXES and if it is 1,2,3,4 then it’s ok else rebuild the index.

Alter index satish. a_satish rebuild unrecoverable;