RE: Questions re: tuning

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Tue, 4 May 2004 18:00:33 -0700
Message-ID: <B5C5F99D765BB744B54FFDF35F60262109F877FC@irvmbxw02>

Another method for 8.1.7:=20
Create a database trigger to store query outlines, then query the outline tables to see if the index has been used. (Tom Kyte, expert one-on-one Oracle)=20

-----Original Message-----
Paul Drake

Leslie Tierstein <Leslie.Tierstein_at_visionchain.com> wrote:

> (1) Naive (?) question

>=20

> Is there an "easy" way to tell if a particular index
> is not being used by
> anything in an application

...

in 8.1.7, one method was to isolate it in its own tablespace. this is not foolproof, as it does not take into account caching, and you have to subtract operations like checkpoint overhead and people running queries against dba_segments for LMTs.

others have suggested a periodic survey of v$bh for blocks of the index, but that is not deterministic.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue May 04 2004 - 19:57:45 CDT