Re: INDEX USAGE

From: http://www.webyourcompany.com <xzhang88_at_hotmail.com>
Date: 5 Jun 2003 21:32:19 -0700
Message-ID: <2f50b64b.0306052032.63a51986_at_posting.google.com>


In Oracle 9i you can enable index monitoring by : alter index <index name> monitoring usage; then

select index_name,monitoring,used,start_monitoring,end_monitoring

      from v$object_usage;

In Oracle 8i.. you can use stored outlines to get it

HTH,
http://www.webyourcompany.com

"Paul" <paul821_at_yahoo.com> wrote in message news:<LreDa.11885$sG3.3834851_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.
Received on Fri Jun 06 2003 - 06:32:19 CEST

Original text of this message