top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Explain Unbalanced Index in Oracle?

+1 vote
Explain Unbalanced Index in Oracle?
posted May 11, 2015 by Suchithra

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

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;

answer May 12, 2015 by Arun Gowda