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, ...
Get Oracle Database 11g PL/SQL Programming Workbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
