Re: SQL Command to report time to execute

It's also true on Windows NT (tkprof)

Vitaliy Mogilevskiy

    Benjamin Butler wrote in message <36C9F466.A938CAE3_at_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