Integrated PL/SQL Profiler (Oracle 8.1.5+)

The PL/SQL Profiler coverage tool is now more tightly integrated into the application.

$image\Sqln0004.gif$ You can access the Locate Object in DB Navigator and Open commands when a stored program is selected in the Profiler’s Runs or Groups tree.

$image\Sqln0004.gif$ You can open the Stored Program Editor and jump to a selected line of source code by by choosing Open from the shortcut menu.

$image\Sqln0004.gif$ Scrolling (moving the cursor position) in the Stored Program Editor selects the corresponding line in the profiler Source Viewer.

$image\Sqln0004.gif$ The server output is automatically retrieved after the run.

$image\Sqln0004.gif$ Session statistics can be displayed on the summary page when a run is selected.

$image\Sqln0004.gif$ The Profiler uses the Oracle session it was activated in. (Previously it used its own session.)

You can launch the Profiler from the Tools menu or the Functions toolbar

$image\Sqln0121.gif$

Using the Locate in DB Navigator command for an open procedure

$image\Sqln0119.gif$

The result of the Locate in DB Navigator command

$image\Sqln0120.gif$

$image\Sqln0291.gif$

Scrolling (moving the cursor position) in the Stored Program Editor selects the corresponding line in the profiler Source Viewer

$image\Sqln0122.gif$