PL/SQL Developer - The PL/SQL Profiler


The PL/SQL Profiler is a very powerful tool to help you optimize your PL/SQL code, which is available on Oracle8i and later. For each executed line of code, the total time, maximum time, minimum time, and the number of occurrences will be determined.

The Profiler is easily accessible in the Debugger's Test Window. Before executing a Test Script, simply press the Create Profiler report button on the toolbar. If you subsequently execute the script, you can switch to the Profiler page to view the report.