Results 1 to 5 of 5

Thread: Procedure Execution Time

  1. #1
    Expert Member
    Join Date
    Sep 2007
    Answers
    697

    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


  2. #2
    Expert Member
    Join Date
    Apr 2007
    Answers
    500

    Re: Procedure Execution Time

    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
    Expert Member
    Join Date
    Nov 2006
    Answers
    518

    Re: Procedure Execution Time

    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-

  4. #4
    Junior Member
    Join Date
    Aug 2008
    Answers
    1

    Re: Procedure Execution Time

    Here i want the exection time without executing the procedure. how can i get this?


  5. #5
    Moderator
    Join Date
    Jun 2007
    Answers
    2,074

    Re: Procedure Execution Time

    Quote Originally Posted by prakashreddy_t View Post
    Here i want the exection time without executing the procedure. how can i get this?
    if you will not execute what is the time you want to get ?


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact