The $ORACLE_HOME/bin/tkprof program has been around as long as I can remember. Oracle continues to improve tkprof by adding wait event and timing information. Essentially, tkprof parses a trace file and formats for human readability. Other tools available that may better suit your budget, formatting, and analysis preferences.

At this point, you may have prepared a trace file for analysis, as well as possibly performance statistics. Now it's your turn to take this information and perform a session-level response-time analysis.

Using DBMS_MONITOR the first few times can be confusing. There is a lot involved to achieve the final reports. To help in this transition, I have included a real-life example here. To get the most from this example, remember the steps outlined in the previous section. You will see the spooled output follows these steps precisely. I have divided the key steps and made comments following each snippet.