Check the view v$object_usage. An Yes or a NO will indicate whether the index is being used.
However if u want to know if a specific query of the application is using an index, you can EXPLAIN PLAN and see the output.
|
Results 1 to 4 of 4
Threaded View
|
Click Here to Expand Forum to Full Width |