to find execution time of query

[madhugp]

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.

[davey23uk]

no, unless you set timing on in sqlplus first

[Scorby]

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.