'How to find hotspot in performance of Oracle stored procedure

we know that one of the stored procedures is taking too much time in execution - having very complex workflow. which tool/method can be used to find hot spot of stored procedure ?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source