Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Finding Index usage.

YasuJan 11 2010 — edited Jan 11 2010
Hi All,

I need to find un-usable indexes and also all the sql queries which are accessing these indexes on a table.

Oracle Database version: 10.2.0.4
OS Version: HP-UX 11.3

I tried by enabling index monitoring.... but it says only whether index has been used atleast once or not.

I required all the sql queries using indexes which exist on this table. Is it possible....????
Required information that whether these indexes can dropped or not(As this table has more than 10 indexes)

-Yasser
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 8 2010
Added on Jan 11 2010
#general-database-discussions
9 comments
1,419 views