O'Reilly logo

Oracle Database 11g PL/SQL Programming by 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 GPL/SQL Hierarchical Profiler Primer

Oracle 11g introduces the PL/SQL hierarchical profiler. The profiler lets you 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 profiler 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 ...

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