How to check if an index created is being used by the application - Oracle 8.1.6

[Dilippatel]

Vipassana, the v$object_usage is included in the 9i, so we may have to rely on the Explain plan.

You can search the queries for the related table from v$sql and then check the queries for the explain plan.