OraFAQ Forum: Server Administration » anyone has a handy index script?

Home » RDBMS Server » Server Administration » anyone has a handy index script?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

anyone has a handy index script? [message #53733]

Tue, 08 October 2002 11:00

tt
Messages: 16
Registered: September 2000

Junior Member

Does anyone have a script in hand that validates every index in a given schema, calculates fragmentation and suggests which ones to rebuild? Thank you,

Report message to a moderator

Re: anyone has a handy index script? [message #53735 is a reply to message #53733]

Tue, 08 October 2002 11:52

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

if you would have analyzed the indexes to validate the structure, following query might help you.

SELECT  name,
        del_lf_rows,
        lf_rows - del_lf_rows lf_rows_used,
        to_char(del_lf_rows / (lf_rows)*100,'999.99999') ratio
FROM index_stats

Report message to a moderator

Previous Topic:	Re: Deleting a datafile
Next Topic:	session memory under MTS configuration

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 14 15:57:27 CST 2025