Re: Measuring query performance - Newbie

Refer to www.sqlpower.com. The Zero Impact Sql Monitor will for every SQL statement sent to the database server report network send time to the server, database server response time, network receive time to client, and total end user response time, rows returned and more.

Scales from 50 to 1000+ users, 50 to 1000+ transactions/second with no impact upon the database server, network and end users.

gabby97_at_my-deja.com wrote in message <7rjjis$4lu$1_at_nnrp1.deja.com>...
>I would like to measure the performance of a SQL statement using
>SQL/Plus. I would like to measure the time it took to execute the query
>and not the time it took for the query to display in SQL/Plus. How do I
>do that?
>
>I have tried using "SET TIMING" command, but I am confused with the
>results that I get back. I get a result that says "real 29345". What
>does that number represent? How do I format the result so it is
>displayed in mm:ss format?
>
>Thanks.
>
>Farzana
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Wed Sep 15 1999 - 07:54:04 CDT