Re: How to determine the number of hits to an Index

From: James Williams <willjamu_at_mindspring.com>
Date: Fri, 25 Jan 2002 23:28:11 GMT
Message-ID: <3c51e998.3737979@nntp.mindspring.com>

On 25 Jan 2002 12:00:09 -0800, leavid_at_rocketmail.com (Dustin Leavitt) wrote:

In 9i you have alter index monitoring usage. Then you can select * from v$object_usage (IIRC).

Prior to that it can be kind of hard. If your indexes are in separate tablespaces you can look in v$filestat is one way off the top of my head.

>Is there any way in Oracle to determine the number of hits that an
>index has? I want to find out if we have indexes that are not being
>used.
Received on Fri Jan 25 2002 - 17:28:11 CST