to find execution time of query
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: to find execution time of query

  1. #1
    Join Date
    Jul 2006
    Posts
    96

    to find execution time of query

    hi friends, how to find execution time of a query?
    or an sql statment like update delete etc..
    because , i want to check the performance , after doing
    some tuning like index rebuild, removing chained rows etc...
    for a table. Is there any dynamic view ? or how to calculate
    time.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    no, unless you set timing on in sqlplus first

  3. #3
    Join Date
    Nov 2001
    Location
    UK
    Posts
    152
    The best option is to do "set timing on" and then "set autotrace trace stat". You can then run your query, it won't spool millions of rows to the screen and it will give you timing + other stats at the end. Alternatively, do an "alter session set timed_statistics=true" and "alter session set sql_trace=true" and get all the timings etc from the trace file.

Posting Permissions

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



Click Here to Expand Forum to Full Width