| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: 10046 Trace and Oracle Time Machine
Raj,
The first thing that comes to mind is that the variable tkprof uses to keep track of elapsed time is not large enough, so it eventually gives bogus values. The fact that the trace file is so large also clues me that actual values for elapsed time are not getting incremented properly (at some point). The other thing I could think of is that the elapsed times are summed together for all parallel processing (but parallel is not indicated in what I see in the file...which means it may or may not exist...I have not used tkprof in so long, I don't recall what it outputs in the Row Source Op.).
That's all I can think of on this Monday morning...
Daniel
 |
 |