O'Reilly logo

Oracle Database 11g PL/SQL Programming Workbook by John M. Harper, Michael McLaughlin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

APPENDIX BPL/SQL Hierarchical Profiler

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

A hierarchical profiler provides you with more insight than a non-hierarchical profiler. A nonhierarchical profiler reports only 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 of hierarchical profiler tables. It divides the data by subprogram units, including the relationship between calling and called subroutines, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required