How to tune package, how can we see the output, which logic taking more time to execute?

Showing Answers 1 - 1 of 1 Answers

Anjani Kumar

  • Aug 9th, 2015

We can use oracle supplied package DBMS_HPROF(New in 11g) to see which procedure and inside that which sql is taking taking more time to execute.DBMS_HPROF Package profiles subprogram calls also with in the procedure.
It gives separate statistics for sql and separate statistics for plsql subprogram.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions