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

Interview Candidate
Aug 6th, 2015
3
7810

First
Prev
Next
Last

Showing Answers 1 - 3 of 3 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.