To know the procedure execution time I have given
SET TIMING ON
After executing procedure it is showing
real: 47
How to display execution time in the following format?
Elapsed: 00:00:03.90
Printable View
To know the procedure execution time I have given
SET TIMING ON
After executing procedure it is showing
real: 47
How to display execution time in the following format?
Elapsed: 00:00:03.90
To find execution time of a procedure ,u can use DBMS_UTILITY.GET_TIME package also
example
DECLARE
time_before BINARY_INTEGER;
time_after BINARY_INTEGER;
BEGIN
time_before := DBMS_UTILITY.GET_TIME;
procedurename;
time_after := DBMS_UTILITY.GET_TIME;
DBMS_OUTPUT.PUT_LINE (time_after - time_before);
END;
This is a good programmatic way of getting the result. :)
But u may c a fraction difference in the time shown by these methods for the same procedure. However it will be negligible.
Here i want the exection time without executing the procedure. how can i get this?
[QUOTE=prakashreddy_t;34158]Here i want the exection time without executing the procedure. how can i get this?[/QUOTE]
if you will not execute what is the time you want to get ?