Re: INDEX USAGE
From: Jusung Yang <JusungYang_at_yahoo.com>
Date: 4 Jun 2003 09:43:10 -0700
Message-ID: <130ba93a.0306040843.5dbd145d_at_posting.google.com>
Date: 4 Jun 2003 09:43:10 -0700
Message-ID: <130ba93a.0306040843.5dbd145d_at_posting.google.com>
"Paul" <paul821_at_yahoo.com> wrote in message news:<LreDa.11885$sG3.3834851_at_news4.srv.hcvlny.cv.net>...
> Can anyone tell me how to find out how frequently an index is used? I
> have many indexes in my SIEBEL system that I don't believe are being
> used, but I don't know how to tell for sure.
>
> Thank you.
Look into v$segment_statistics.
- Jusung Yang