Profiling PL/SQL

Oracle Database 11g introduced the PL/SQL Hierarchical Profiler which records not only the time spent in each sub program, but also (arguably, more useful) the number of calls to the subprogram.

The detail is stored in a set of database tables, which you can run custom reports against to retrieve. The package DBMS_HPROF provides procedures that start and stop the hierarchical profiler data collection. Instead of managing this process manually and from a command line, SQL Developer provides the tools to create these tables, set up the environment, and a set of reports for you to review the output.

Note

The PL/SQL Hierarchical Profiler was introduced in Oracle Database 11g. Integration with SQL Developer was introduced in release 1.5, and is only available in the user interface when accessing Oracle Database 11g Release 1 and above.

Getting started

To run the profiler, once you have a compiled subprogram, invoke the PL/SQL code editor for the selected code:

The same window that...