Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How can I find the time a query takes to complete

Re: How can I find the time a query takes to complete

From: John Koo <johnkoo_at_i-wave.net>
Date: Mon, 25 Jan 1999 07:24:08 +0000
Message-ID: <36AC1C18.84DC807@i-wave.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US