To diagnose PL/SQL performance problems, Oracle provides the Hierarchical profiler. The profiler produces a stack trace with timings. After feeding this trace into the Oracle provided tools a bunch of html files are created that provide you with all sorts of aggregates to find the performance bottleneck in your PL/SQL code. Imagine all those numbers…