Tell Me
 

Profiling PL/SQL
Previous previous|next Next Page

Profilers are used to record the time each program spends within each of its sub programs. With Oracle Database 11g, Hierarchical profilers are available. Hierarchical profilers provide additional sub program level execution summary. This information is stored in database tables called the hierarchical profiler tables.

You can use the profiler feature of SQL Developer to analyse the execution of your PL/SQL applications. Profiling in SQl Developer consists of two steps:

  1. Running the PL/SQL program in Profile mode.
  2. Analyzing the reports.

In addition, you need to perform some steps the first time you use profiling in SQL Developer.