Using the PL/SQL Profiler
Profiling PL/SQL enables you to see how long your code took to execute and how long each line of code took to execute. This is important information to have when you’re tuning PL/SQL code or a complete set of related routines.
Starting with version 8i, Oracle can track statistics on the execution of SQL, including procedures and functions. Toad interfaces with the DBMS_PROFILE (you will need execute privileges for this package) package, giving you an easy way to track and compare your program statistics. This package then populates three tables in the user’s account:
PLSQL_PROFILER_RUNS
PLSQL_PROFILER_UNITS
PLSQL_PROFILER_DATA ...
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.
