RE: Questions re: tuning
- From: "Jacques Kilchoer" <Jacques.Kilchoer@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 4 May 2004 18:00:33 -0700
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@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
