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…