RE: Questions re: tuning

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.