Measuring query performance

From: <gabby97_at_my-deja.com>
Date: Mon, 13 Sep 1999 19:24:54 GMT
Message-ID: <7rjj1j$476$1@nnrp1.deja.com>

I would like to measure the performance of a query, but I am not sure how to do this? I would like to do this using SQL/Plus. I have tried to use the "SET TIMING" command, but I am confused with the results that I get back. It says "real 29342". What does real represent - time in milliseconds, microseconds? How do you format the time so it is displayed as minutes:seconds etc?

Also, I would like the time to just execute the SQL statement and not the time to display the contents on the screen? How do I do that?

Thanks.

A newbie,
Farzana

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Sep 13 1999 - 14:24:54 CDT