Re: index statistics

> > Index monitoring is only going to work if your version is at least 9i,
> > if I remember well.
> >
> > Daniel
>
> Hello,
> thanks for help!
> Yes we use Oracle 9i.
> Now we can look which index has already been used, but not, how often.
> Is ther any way to get this information too.
>
> thanks Heiko

To get a "ballpark" idea of how often an index is used, I'd periodically take a look at the contents of the shared pool during/after periods of high activity (hint for you: column OBJECT_NAME of dynamic view V$SQL_PLAN).

HTH Daniel Received on Thu Apr 29 2004 - 16:15:52 CEST