How do I track down wait events for a specific transaction in Oracle Enterprise Manager? I have an application that makes tens of thousands of calls per day to a stored procedure.  Normally this executes in about 50 ms.  However, periodically, it takes 2-3 seconds to execute.  I have an application log file that shows what time and how long each call to the stored procedure took.  I'm wondering...how can I track down this exact transaction within Oracle Enterprise Manager and display the associated wait events so that I can understand why this specific call is taking so long to execute.
The ASH report shows top wait events, top SQL and top sessions. Using Enterprise Manager, you can generate the ASH report by navigating to the performance page and then clicking 'Run ASH Report'. On thhe performance page, you can also click the 'Top Activity' link. On the Top Activity page, you can then choose a time interval by dragging the shaded area(may have different drag controller version to version and browser to browser), and then click Run ASH Report.
For details:
Identifying High-Load SQL Statements