Graphic profiler for optimizing stored programs

You can use the integrated Coverage/Profiling tool to analyze the execution time and efficiency of your stored programs. (Oracle 8.1.5 or higher.)

The PL/SQL Profiler provides easy-to-use profiling, including execution time statistics and coverage analysis, for PL/SQL developers. Unlike the profiling utilities provided with Oracle 8.1.5 and later, the PL/SQL Profiler tool is graphical and allows easy navigation and drill-down through the data. The Profiler is particularly useful for

$image\Sqln0004.gif$ finding bottlenecks in stored code

$image\Sqln0004.gif$ quality assurance and testing.

The Profiler will show you a line-by line analysis of the execution, including the number of times each line was executed and the time required for execution.

Summary and statistics results from a profiling run

$image\Sqln0123.gif$