This content has been marked as final. Show 2 replies
This allows executing a query without returning the results. It also provides execution statistics and the explain plan, which you may be interested in anyway if the timing is less than acceptable.
set timing on set autotrace traceonly
disable autotrace with
set autotrace off
Note however that the timing alone will not actually yield much value, use trace with tkprof, autotrace or a tool like [url http://asktom.oracle.com/pls/apex/ASKTOM.download_file?p_file=6551378329289980701]runstats to get meaningful answers. Also, termout off will only work when inside a script.
set termout off timing start t1 select * from hr.employees / set termout on timing stop t1