Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Index management
"Richard Foote" <richard.foote_at_tbigpond.nospam.com> wrote in message news:<5Vtkc.5521$TT.227_at_news-server.bigpond.net.au>...
> "DiggidyMack69" <DiggidyMack69_at_hotmail.com> wrote in message
> news:c86ce4f.0404300648.63277bc8_at_posting.google.com...
> > Are there supplied scripts, packages, or procedures that will find and
> > rebuild existing index's? What I am really looking for is a script to
> > be run to rebuild fragmented index's as needed.
>
> Go to the download section at www.actoug.org.au, make what you can of the
> PowerPoint presentation, wait for the accompanying whitepaper/book, read it
> carefully too and hopefully you'll get the picture.
>
> Cheers
>
> Richard
This one popped up in my email:
http://searchoracle.techtarget.com/tip/0,289483,sid41_gci960148,00.html?track=NL-94&ad=482086
For those who don't want to register there, it basically does an analyse index validate structure on all non-sys% indices, then builds a rebuild command if > 20% of the leafs are deleted.
Interested in people's opinions on it, rants about arbitrary percentages always appreciated.
jg
-- @home.com is bogus. After performing for the British royal family, the story goes, he was introduced to Queen Elizabeth. "How do you do, Mr. King?" she is reported to have said. "How do you do, Mrs. Queen?" he is said to have replied. RIP Irwin Alan Kniberg 1927 - 2004 AKA Alan KingReceived on Mon May 10 2004 - 18:16:38 CDT