Re: INDEX USAGE

From: Steve Howard <stephen.howard_at_us.pwcglobal.com>
Date: 4 Jun 2003 05:34:56 -0700
Message-ID: <6d8b7216.0306040434.63637f4b@posting.google.com>

"Paul" <paul821_at_yahoo.com> wrote in message news:<DseDa.11886$sG3.3838538_at_news4.srv.hcvlny.cv.net>...
> 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.

If you're running 9.x, you can issue the following:

alter index index_name monitoring usage;

then query v$object_usage.

Regards,

Steve Received on Wed Jun 04 2003 - 07:34:56 CDT