Procedure Execution Time

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 ?