Toad and the PL/SQL Profiler
Oracle introduced the PL/SQL Profiler back in Oracle8i. Toad has a nice interface to this feature.
The Profiler will gather execution times for each PL/SQL procedure or function being profiled, and execution time for each line of code. This information displays how long each module took to execute and how long each line of code took to execute.
This feature really saves a lot of developers’ time when tuning PL/SQL.
Note
If the Profiler database objects are not set up, Toad will prompt you to set them up. If you need assistance when this information is requested by Toad, contact your DBA staff.
Figure 10.24 shows the Looping_Example procedure open in the Editor window. Refer to Chapter 6, “Working with PL/SQL
Get Toad for Oracle Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
