From: get4ked@yahoo.com (Ford)
Newsgroups: comp.databases.oracle.server
Subject: Re: Auditing on using indexes
Date: 8 Aug 2001 13:14:38 -0700
Organization: http://groups.google.com/
Lines: 12
Message-ID: <b2b9197f.0108081214.7f4051d8@posting.google.com>
References: <9kricm$t383@imsp212.netvigator.com>
NNTP-Posting-Host: 148.87.1.170
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 997301679 5257 127.0.0.1 (8 Aug 2001 20:14:39 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 8 Aug 2001 20:14:39 GMT


Not till 9i - there is a new feature which allows you to monitor an
index for usage - check the administrators guide or the new features
guide.

"Ken Shan" <kenxuauh@hotmail.com> wrote in message news:<9kricm$t383@imsp212.netvigator.com>...
> Hi there,
> 
> There are many indexes created on our database, but how can I know which
> indexes are used by the SQLs or which indexes are no longer used ?  Is there
> any ulitilities or tools ? thanks
> 
> Ken