Re: Auditing on using indexes

From: Ford <get4ked_at_yahoo.com>
Date: 8 Aug 2001 13:14:38 -0700
Message-ID: <b2b9197f.0108081214.7f4051d8@posting.google.com>

Not till 9i - there is a new feature which allows you to monitor an index for usage - check the administrators guide or the new features guide.

"Ken Shan" <kenxuauh_at_hotmail.com> wrote in message news:<9kricm$t383_at_imsp212.netvigator.com>...
> Hi there,
>
> There are many indexes created on our database, but how can I know which
> indexes are used by the SQLs or which indexes are no longer used ? Is there
> any ulitilities or tools ? thanks
>
> Ken
Received on Wed Aug 08 2001 - 15:14:38 CDT