Re: index statistics

From: Daniel Roy <danielroy10junk_at_hotmail.com>
Date: 29 Apr 2004 07:15:52 -0700
Message-ID: <3722db.0404290615.1fa24861@posting.google.com>

> > 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 - 09:15:52 CDT