Re: Trace file does not list detailed timings

Thanks Jonathan,

I guess the main performance penalty comes from gettimeofday() calls, because the rowsource stats do have time in them too?

Tanel.

> I did a couple of quick checks of sample
> frequency with one of my stress tests a
> few months ago.
>
> without sampling ca. 2 seconds
> with default sampling (128) ca. 6 seconds
> with sample size = 1 ca. 10 seconds
>
> Obviously dependent on the number of times
> a line of the execution plan is started, so most
> sensitive to nested loop types of activity.
>

--
http://www.freelists.org/webpage/oracle-l