RE: Index Usage

Hi,

There is a "magical" tool called Oracle Expert if you have money to pay for OEM and the Tunnig (or Diagnostics I canīt remenber just now) Pack.

Another cheaper way is if you have your index or group of indexes isolated in their tbs. Just look to the read statistics on that TBS, or run utlbstat / utlestat over a signifivative period of time and look for those statistics.

HTH         Joselu

> -----Mensaje original-----
> De: Lisa_Koivu_at_gelco.com [SMTP:Lisa_Koivu_at_gelco.com]
> Enviado el: martes 9 de mayo de 2000 18:15
> Para: Multiple recipients of list ORACLE-L
> Asunto: RE: Index Usage
>
> Do you mean explain plan? I don't have time to explain all the reports.
> Besides I am now pushing that back to the DEVELOPERS. :) They need to
> learn
> how to execute and interpret this sometime.
>
> I was wondering if there was some magical way to look somewhere and see
> how many
> times an index has been hit in the last 12 hours or so.
>
>
>
>
>
>
>
>
> Miguel Urosa <murosa_at_smseuropa.com> on 05/09/2000 10:51:51 AM
>
> Please respond to ORACLE-L_at_fatcity.com
>
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> cc: (bcc: Lisa Koivu/GELCO)
>
>
>
>
> 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).
>
>
>
>
>
>
> --
> 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
Received on Tue May 09 2000 - 11:10:19 CDT