If you're on 9i, you can use STATSPACK and SQL Trace; on 10g, you use the automatic database diagnostic monitoring (ADDM) facility. Check your documentation for details on these.
Dig Deeper on Oracle database performance problems and tuning
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.