How will you get the executation time of procedures or fuctions in the package?.which one is taking somuch time?.

  • Interview Candidate
  • 3
  • 2571

Showing Answers 1 - 3 of 3 Answers

Harish

  • Sep 21st, 2006
 

I am not sure that there is a function to find out the execution time of the procedures and functions. But I can tell you a method to do it.

Print time at the first and last line of the procedure and function. Execute both. You can get the time interval.

  Was this answer useful?  Yes

Priya

  • Sep 26th, 2006
 

You can use DBMS_UTILITY.GET_TIME procedure.

  Was this answer useful?  Yes

Ashish

  • Sep 28th, 2006
 

Use DBMS_PROFILER to tell you exactly which lines in the PL/SQL code are taking time.

  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