How much time did I spend where in my PL/SQL? AWR and trace will identify recursive SQL, but it can be hard to determine exactly how much time is spent where in the procedural code. The PL/SQL profiler will report individual code blocks, reporting elapsed time and numbers of executions.
The presentation is available in a zip file in pdf format with demonstration scripts.
A video of this presentation is also available.