Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How can I find the time a query takes to complete
Paul Martin wrote:
> Hello
>
> Is there a way to find the time (in seconds) a query takes to run on a
> database. I know I can put the database into 'trace mode' which will
> generate a trace file. However is there any other way to time a query.
> What I would like to do is to have a program which will query something (if
> possable a table) containg the elapsed times for the query's taking place
> and send me a message if a query takes longer than a certin predefined time.
>
> Sincery
>
> Paul
>
> prmartin_at_bluewin.ch
Maybe you can also try to "set timing on" in sqlplus...it is simple to use.
John Koo
johnkoo_at_i-wave.net
Received on Mon Jan 25 1999 - 01:24:08 CST