Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2008
    Posts
    14

    Question Unanswered: Procedure Execution Time

    Hi,

    I have a procedure 'A' which calls other procedures within, say 'B','C'.

    Iam trying to find the execution time for each of these procedure.

    Iam able to find the execution time for proc 'A' by using

    SET TIMING ON

    However what I need is to find which procedure within A is taking more time.

    Would be very helpful if anyone can suggest some method for the same.

    Thanks

  2. #2
    Join Date
    Jun 2009
    Posts
    7
    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;

  3. #3
    Join Date
    Mar 2008
    Posts
    14
    Hi,

    Thanks a lot for the suggestion

    I had tried this. But got the execution time(difference b/w Start and End Time) as 0.

    Is it because the Procedure executed very fast ?

  4. #4
    Join Date
    Jun 2009
    Posts
    7
    no it should show some negligable value.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •