-
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.
-
no, unless you set timing on in sqlplus first
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|