Re: INDEX USAGE

From: Rob Cowell <rjc4687_at_hotmail.com>
Date: Wed, 04 Jun 2003 08:15:41 +0100
Message-ID: <3EDD9C9D.6FF8A7F1@hotmail.com>

> Paul wrote:
>
> Can anyone tell me how to find out how frequently an index is used? I
> have many indexes in my SIEBEL system that I don't believe are being
> used, but I don't know how to tell for sure.
>
> Thank you.
> --
> Paul LaBarbera
> Randolph, NJ

In 9i you can use ALTER INDEX index_name MONITORING USAGE

If you're on 8/8i have a search on Metalink. There's some code there that captures parsed code from the library cache, generates the explain plan and logs the indexes used. Obviously you need to run this more frequently than objects get flushed from the cache. Received on Wed Jun 04 2003 - 02:15:41 CDT