- Ask questions about expectations such as what is expected time for the particular application activity.
- Based on the expectation, look at the areas of application which is taking more time.
- Use oracle database tools to figure out the queries/process which is taking more time at database.
- Use AWR report, ADDM report, ASH report, Trace file or Explain to figure out the problamatic area.