Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to measure sort time
> steps in terms of memory usage, whereas I'm interested in sheer time, with
> the maximum precision.
Hmm... Whatever tool you use you might get high precision, but not high accuracy. There are many things that can make a database take longer or shorter to run the same exact query. If your benchmark thingie tells you a query runs in 11.546 seconds, that might be true, but the next time you run the query it will probably run in a somewhat different time.
In other words, if you need a ball-park time for your query, using your watch's seonds hand will be enough... Received on Tue Mar 18 2003 - 17:55:29 CST
![]() |
![]() |