Re: How can I see when the last time was an index was used?

Bert Haverkort wrote:
>
> Hello,
>
> I have a simple question.
>
> How can I see when the last time was an index was used? Not created or
> changed, but used.

Hmmh, I don't believe that the v$ views contain such an information.

If it is sufficient to know if an index _was_ used recently, you could query the shared SQL area (V$SQLAREA + V$SQLTEXT) and perform a batch explain ("EXPLAIN PLAN ...") with each statement in order to see, what objects underlie the execution plans.

Uwe

-- 
Uwe Schneider       | Telefon +49 7244 / 609504
Karlsdorfer Str. 31 | Mail    uwe_at_richard-schneider.de
DE-76356 Weingarten | http://www.richard-schneider.de/uwe
Linux - OS al dente!