And there's the ALTER INDEX index_name MONITORING USAGE command available to
you in 9i, if you're on that release.
--
HTH. Additions and corrections welcome.
Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
"Chuck Hamilton" <chuck_hamilton_at_hotmail.com> wrote in message
news:9krlip$67ebi$1_at_ID-85580.news.dfncis.de...
> "Ken Shan" <kenxuauh_at_hotmail.com> wrote in message
> news:9kricm$t383_at_imsp212.netvigator.com...
> : Hi there,
> :
> : There are many indexes created on our database, but how can I know which
> : indexes are used by the SQLs or which indexes are no longer used ? Is
there
> : any ulitilities or tools ? thanks
> :
> : Ken
> :
> :
>
> The tuning pack includes a tool called "tuning expert" or something like
> that which will tell you which indexes are being used. If you don't want
to
> buy that, you'll need to monitor the SQL area of the shared pool and
capture
> all sql that's using the table (don't forget views too), and run an
explain
> plan on each to see if the index is being used.
>
>
Received on Wed Aug 08 2001 - 17:13:19 CDT
