Hi all,
How to see if my index are fragmented? If I want to rebuild index, anything I should be aware of? (performace would be bad, so I won't run rebuild script during peak time)
oralce 8.0.5.2.1 on NT4.0
Index size about 15G
Thank you
Printable View
Hi all,
How to see if my index are fragmented? If I want to rebuild index, anything I should be aware of? (performace would be bad, so I won't run rebuild script during peak time)
oralce 8.0.5.2.1 on NT4.0
Index size about 15G
Thank you
hi,
use rebuild online option
Hi,
If u want to see if ur indexes are fragmented ,please run the following command and view the INDEX_STATS table to get the statistics in the same session.
sql>analyze indexvalidate structure;
Index analyzed
sql>select name,(del_lf_rows/lf_rows)*100 "Percentage" from index_stats
If the percentage is equal or greater than 20% rebuild the index.Also rebuild the index at off-peak hours usually in the night.
In case of any help please be free to ask me at rohitsn@altavista.com
Regards.
Rohit Nirkhe,Oracle DBA,OCP 8i
rohitsn@altavista.com