Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to measure sort time
"Maciej Sobczak" <maciej_at_maciejsobczak.com> wrote in message news:<b57mqe$4n9$1_at_SunSITE.icm.edu.pl>...
> Hi,
>
> How to measure the time of sorting in Oracle 8.1.6 and higher?
>
> My current approach with SQLPlus is to "set timing on", and throw some
> select statement with order by clause against the serwer, but considering
> the output it seems that the time spent on spitting the data on the console
> is also taken into the summary timings.
>
> What is the preferred way to measure only the sorting time? Are there some
> more advanced approaches/tools?
>
> Thank you for your time.
Interesting though. I don't think this shows up in sesstat or session_event. The sort stuff in sesstat is only # of sorts, not time duration. Don't think this is in tkprof either.
The closest I can think of is, under a controlled environment, do a before and after difference of v$filestat, get temp file's writetime. This also assumes that you are only interested in this when it is sorting on disk. Received on Wed Mar 19 2003 - 13:37:11 CST