Re: time of execution

In article <9no4i8$bdb$1_at_talia.mad.ttd.net>, "Félix" says...
>
>Hello, I'd want to know if there is a way
>to know the time of execution of a SQL query.
>Thanks
>
>

in sqlplus, set timing on

in general, alter session set sql_trace=true and use tkprof (see http://osi.oracle.com/~tkyte/tkprof.html for a redirect to the documentation). Make sure timed_statistics=true.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp