Re: Unused indexes

This only works for Oracle8 ! Not 7.3

Anjo.

Connor McDonald wrote:

> Boris Oblak wrote:
> >
> > Hi,
> >
> > How can i found unused or inefficient indexes on Oracle 7.3 or Oracle8?
> >
> > Thanks,
> > Boris
> >
> > e-mail:boris.oblak_at_k2.net
>
> You could always scan x$bh at period intervals, join to OBJ$ for TYPE#=1
> which will tell you what indexes are in the buffer cache...
>
> --
> ===========================================
> Connor McDonald
> "These views mine, no-one elses etc etc"
> connor_mcdonald_at_yahoo.com
>
> "Some days you're the pigeon, and some days you're the statue."
Received on Thu Nov 25 1999 - 03:24:41 CST