Re: When was indexed last used?

Ethan Post wrote:
>
> Sorry this one might actually need version for this:
>
> 8.0.4.4.0
>
> In article <8jgfnd$vro$1_at_nnrp1.deja.com>,
> Ethan Post <epost1_at_my-deja.com> wrote:
> > What is the easiest way to determine the last time an index was used
 by
> > the instance. Used as in last time it was included in the execution
> > plan of a query. I would like to get rid of a few indexes that are
> > huge and I'm pretty sure are not being used but can not be sure.
> >
> > Thanks,
> > Ethan
> > http://www.freetechnicaltraining.com
> > http://www.gnumetrics.com
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> --
> http://www.freetechnicaltraining.com/home/ethan
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

A possible way (not entirely accurate) is to regularly scan the buffer cache (X$BH) for blocks from that index. I can't remember off hand but you need to check some of the flags as well since when you write to the table the buffer cache will get some of the index blocks as well.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse