Oracle Database Discussions

Hello All,

I had a bad interview yesterday for Oracle Database Administration job and was a developer who ask me a question about performance tuning that I couldn't answer him; the question was like

A developer come to you with a query that he issue to a database and he complain that it is too slow and the system is hang how can you solve the problem?
describe the steps that you have to follow to take care of this issue

Can some one give me an Idea on how to solve these type of problem, the steps
I assume it has to do with AWR, ASM, ADDM, AMM
I am a very new oracle DBA just certify with no experience that is why i found it difficult

Need help

Thanks
Nounou