Re: Time a sql statement

Hi Allan,

alter session set sql_trace = true;
<your doubtful statement goes here>
alter session set sql_trace = false;

Then you have a look in your user_dump_dest if you ran this in dedicated server connection and in background_dump_dest when done in shared server and view the respective trace file with tkprof:

tkprof <the generated trc file> out.txt userid=<whatever>

Regards,

Martin

godmann wrote:
>
> Adrian,
>
> set timing on gives you the round trip. How am I getting the
> ACTUAL execution time of an SQL statement without using stakspack
> for this moment. Oracle 7.3.4.5 is in use!
>
> Allan W. Tham
> Oracle DBA
Received on Fri Mar 08 2002 - 02:33:24 CST