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

GeekInterview.com > Interview Questions > Oracle

Go To First | Previous Question | Next Question

Oracle | Question 34 of 81

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

Total Answers and Comments: 3

Last Update: September 28, 2006 Asked by: Sudhiranjan

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

September 21, 2006 23:29:45

Harish

RE: How will you get the executation time of procedure...

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.

Is this answer useful? Yes | No

September 26, 2006 07:28:57

Priya

RE: How will you get the executation time of procedure...

You can use DBMS_UTILITY.GET_TIME procedure.

Is this answer useful? Yes | No

September 28, 2006 06:05:25

Ashish

RE: How will you get the executation time of procedure...

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

Is this answer useful? Yes | No

User Name		Remember Me?
Password

Question Bank