|
|
|
 |
The Professional Edition of SQL Insight contains all features within the Standard Edition, and introduces advanced solutions for PL/SQL profiling and debugging. Using this feature set provides the developer instant identification of coding complications and performance problems.
The additional feature set provided in the Professional Edition includes:
 Profile PL/SQL anonymous blocks and stored methods
View drill-down time charts of executed units and lines of code
Store line text for versioning comparisons
Debug PL/SQL anonymous blocks and stored methods
Full featured code stepping
View and modify variables
Navigate through the execution's call stack
Set breakpoints and specify individual behaviors for each
Integrated Debugger
The Integrated PL/SQL Debugger allows a user to diagnose complications within anonymous PL/SQL blocks and underlying methods (packages, procedures, etc.). The debugger comes equipped with the ability to set and control the attributes of breakpoints, exception handling, variable value hints, the call stack, a variables list, and evaluating or modifying variable values.
PL/SQL Profiler
SQL Insight's Profiler interface grants the ability to execute and cache statistical information on PL/SQL blocks and methods (packages, procedures, etc.). The Profiler Analysis displays this statistical information allowing a user to compare executions or view the execution statistics line by line to determine performance problems.
|
|