If you are asking about an index being used for a specific SQL statement,
then yes, use the explain plan. If you are asking the broader question of
is the index being used at all throughout the day's processing, here's what
you can do. Create a dummy tablespace with 1 datafile that will only hold
your index. Rebuild the index into this tablespace. Check v$filestat at
the end of the day and see if there have been any physical read or writes.
>From: Miguel Urosa <murosa_at_smseuropa.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Index Usage
>Date: Tue, 09 May 2000 07:51:52 -0800
>
> What about to use PLAN SQL statement?.
>
> HTH.
>
> Miguel.
>
> -----Mensaje original-----
> De: Lisa_Koivu_at_gelco.com [SMTP:Lisa_Koivu_at_gelco.com]
> Enviado el: martes 9 de mayo de 2000 17:10
> Para: Multiple recipients of list ORACLE-L
> Asunto: Index Usage
>
> Hello -
>
> Does anyone have a quick and dirty way to tell if an index is being
>used? This
> is a DW environment.
>
> Thanks
> Lisa
>
>
>
>
>
> --
> Author:
> INET: Lisa_Koivu_at_gelco.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
>Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>--
>Author: Miguel Urosa
> INET: murosa_at_smseuropa.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.com
Received on Tue May 09 2000 - 10:07:08 CDT
