Rebuild Indexes

From: vidya kalyanaraman <vidya.kalyanaraman_at_oracle.com>
Date: Fri, 13 Feb 2004 14:15:48 +0530
Message-ID: <402C8EBC.1010101@oracle.com>

Hi
 It may be a silly thing to ask, but I am stuck right now.  I have been given a task to find out the indexes which need to be rebuilt. There are around 3000 Indexes. I know I can run the following command
 "analyze index <Index> VALIDATE STRUCTURE "

for a single index and then find the rows from index_state based on del_lf_rows_len/lf_rows_len > 20%.
Does anyone have a script for dynamically finding out the indexes that are the candidates for rebuilding? How do you normally handle situations like this?

TIA
Vidya

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Fri Feb 13 2004 - 02:45:48 CST