Re: How to measure sort time

Hi!

You could also set sort statistics on by event 10032. Timing information (and more) is stored in udump then.

Just an example:
alter session set events '10032 trace name context forever, level 16';

Tanel.

"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.
>
> --
> Maciej Sobczak
> http://www.maciejsobczak.com/
>
>
>
Received on Sat Mar 22 2003 - 13:23:18 CST