I have recorded a brief demo to illustrate using the PL/SQL Hierarchical Profiler in SQL Developer.
Not only do you need Oracle 11g, you also need to have access to a set of tables and a new package
called DBMS_HPROF. SQL Developer takes control of setting this up and so you need only acknowledge the steps being taken. If you don't want SQL Developer to create the required profiler tables, review the 11g documentation and ensure you set this up before hand.
Once you have created a profile you can review the detail. The reports provided include details such as:
- Number of calls to the subprogram
- Time spent in the subprogram itself
- All subprograms that a given subprogram called (children)