Thanks again Halo.

This application is a web based application and it generates tons of SQLs and it would
be a painful task for me to trace the instance and do the analysis.

I know Quest Software has a tool (SQL*Impact ???) that would generate a report of "unused" indexes.
I can not use this tool since I do not have direct access to the database machine.
THat is why I am asking if there any SQL query that can be run to identify "unused" indexes.