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 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.
Lack of WILL POWER has caused more failure than
lack of INTELLIGENCE or ABILITY.
-sutnarcha-
Here i want the exection time without executing the procedure. how can i get this?