Re: SQL Command to report time to execute

From: Benjamin Butler <benjamin.butler_at_lineone.net>
Date: Tue, 16 Feb 1999 22:42:46 +0000
Message-ID: <36C9F466.A938CAE3@lineone.net>

Hello.

In SQLPlus 3.* there is in the Options menu, set timer on which will return the time taken to execute your SQL. Alternatively you can set the trace on before you run your SQL and then set it off again to create a trace file. You can then use tkprof (in Unix) to run the file and this will give you a whole wealth of statistics about your SQL. Speak to your DBA for more details on how to do this.

Ben

joe.geter_at_somills.com wrote:

> What SQL command will give the time it takes to return data from issuing
> a select statement?
>
> TIA,
>
> Joe
Received on Tue Feb 16 1999 - 16:42:46 CST