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>
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