Database Reference
In-Depth Information
Using a GUI
In addition to the methods covered in the previous sections, it's also possible to use one of the graphical interfaces
available in third-party products. Such an interface is provided by SQL Developer (Oracle) and Toad (Dell). These
tools can be used to profile code, usually by clicking a check box or button before running a test, or by simply
analyzing the content of the output tables.
Figures
3-6
through
3-8
show part of the information provided by SQL Developer for the profiling session
illustrated in the previous sections.
Figure 3-6.
Profiling data at the namespace level displayed in SQL Developer
Figure 3-7.
Profiling data at the module level displayed in SQL Developer