Oracle Database 12c PL/SQL Programming

APPENDIX

G

PL/SQL Hierarchical Profiler Primer

The PL/SQL hierarchical profiler, introduced in Oracle Database 11g, enables you to capture the dynamic execution performance of your PL/SQL programs. It divides PL/SQL execution times into two parts: SQL statement execution times and PL/SQL program unit execution times.

A hierarchical profiler provides you with more insight than a nonhierarchical profiler. A nonhierarchical profiler only reports how much time a module consumed. A hierarchical profile tells you which program called what subroutine and how many times the subroutine was called. The PL/SQL hierarchical profiler stores results in a set ...