Re: index statistics
Date: 29 Apr 2004 07:15:52 -0700
> > Index monitoring is only going to work if your version is at least 9i,
> > if I remember well.
> > Daniel
> 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