Re: Unused indexes

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 15 Nov 1999 20:21:33 +0800
Message-ID: <382FFACD.13AB@yahoo.com>

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 Mon Nov 15 1999 - 06:21:33 CST