Board index Oracle

Measuring query performance

Measuring query performance

Post by gabb.. » Sun, 31 Dec 1899 09:00:00



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.

 
 
 
Top

Measuring query performance

Post by Daniel P. Considin » Sun, 31 Dec 1899 09:00:00


use tkprof with the explain option
in the doco for oracle tuning

 
 
 
Top

1. Measuring query performance - Newbie question

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.

2. Table sizing in Sybase

3. Measuring query performance - Newbie

4. INput from a text file.

5. Measure query performance

6. Monitor Server SQL?

7. sql server performance measure for queries

8. SQL doclet

9. How to measure the performance of a query?

10. Measuring performance effectby a query

11. SQL Server Performance Problem - Good query performance, bad update performance

12. performance with AS & calculated measures


All times are UTC
Board index