-
Book Overview & Buying
-
Table Of Contents
Oracle SQL Developer 2.1
By :
Once your PL/SQL code has successfully compiled, it is important to review it to make sure it does what is required and that it performs well. You can consider a number of approaches when tuning and testing code. These approaches include:
Debugging—run the code and add break points to stop and inspect areas of concern.
SQL performance—use Explain Plan results to review the performance.
PL/SQL performance—use the PL/SQL Hierarchical Profiler to identify bottlenecks.
Unit testing—review edge cases and general function testing. Does the code do what you intended it to do?
In this section, we'll review the debugger. In the next chapter, we'll look at the Explain Plan and Hierarchical Profiler.
SQL and PL/SQL code may execute cleanly, and even produce an output. PL/SQL code may compile and produce results, but this is part of the task. Does it do what you are expecting it to do? Are the results accurate? Does it behave as expected for high and low values...
Change the font size
Change margin width
Change background colour