The need for rebuilding indexes is felt essentially by looking at the blevel column in the dba_indexes view. A value of 3 or 4 or more is an indication for need to rebuild the index [good for btree indexes]. The number can usually be greater in bitmap indexes. I just tried to create a sql for you that you can use to find the desired information in your database:

select owner, index_name, blevel from dba_indexes where blevel >= 3 and owner not like 'SYS%';

I hope it helps you.

Gurmohan
www.freemath.info

-----------------------------------------------------------------------------------

-----Original Message-----
From: George
[mailto:oracledba-ezmlmshield-x72083768.[Email address protected]
Sent: Wednesday, June 29, 2005 1:57 AM
To: LazyDBA Discussion
Subject: RE: Rebuild Indexes


Hi DBA's



Can any body having scripts which will show what are the indexes/list of
indexes need to be rebuild ?



Thanks in advance

George





--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page