From: xzhang88@hotmail.com (http://www.webyourcompany.com)
Newsgroups: comp.databases.oracle
Subject: Re: INDEX USAGE
Date: 5 Jun 2003 21:32:19 -0700
Organization: http://groups.google.com/
Lines: 19
Message-ID: <2f50b64b.0306052032.63a51986@posting.google.com>
References: <LreDa.11885$sG3.3834851@news4.srv.hcvlny.cv.net>
NNTP-Posting-Host: 64.180.193.181
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1054873939 29091 127.0.0.1 (6 Jun 2003 04:32:19 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 6 Jun 2003 04:32:19 GMT


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@yahoo.com> wrote in message news:<LreDa.11885$sG3.3834851@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.