Re: Trace file does not list detailed timings

  • From: Tanel Põder <tanel.poder.003@xxxxxxx>
  • To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 30 Jan 2006 14:00:30 -0600

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.


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


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 01-2006