how do i find the used and unused indexes

[patel_dil]

If you are using Oracle 9i, you can use Index MONITORING USAGE clause and query the v$object_usage to see that the index has been used.

HTH.