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


Other related posts: