My application runs very slow after I did a database import.
I doubt there is some problem in the indexes. I have the list of indexes used by my application with me.

What all checks I can perform ( in Oracle 8.1.7.4 ) to confirm that all my indexes have been created and working fine.