Re: Time a sql statement

On 27 Feb 2002 18:29:04 -0800, allanwtham_at_yahoo.com (godmann) wrote:

>Hi there,
>
> In sqlplus, how do you go about to time a sql statement? I want
>to know how many msec it takes for a particular *doubtful* statement.
>
>Allan W. Tham
>Oracle DBA

Use Set Timing On

This will give u the Elapsed Time in MS for each stmt executed.

HTH [Additions and Corrections Always Welcome.] Best Regards,
Ganesh R Received on Wed Feb 27 2002 - 23:50:12 CST