RSS Feed

Method R Discussion Group

I and my college use different version of Profiler. my version is 5.1.16.0, his version is 5.1.8.0. When we ran on different machines with same input file, my output file didn't get timing information in section 4.1.4 Execution Plans and Placeholder Values and he gets timing information. that means I only get “rows returned”, “oracle CR buffer gets”, “Oracle blocks manipulated by OS” and missing “Duration of self” and “Duration incl descendants”.
How do I get timing information with my version of Profiler?

Thanks

Yan,

It looks like from your support case (case 1854), using the setting SHOW-NEGATIVE-ROW-SOURCE-TIMINGS="True" has given you the behavior that you want.

Some of the Profiler code path that has evolved the most rapidly over the past several releases is how we should handle the rendering of row source operation timing data when the data are "sensed" to be unreliable. You can see the details at https://portal.hotsos.com/products/P5/changelog. To summarize:

- In 5.1.9 (2006/05/26), we fixed a number of inaccuracies in how the Profiler rendered execution plans. I believe this is the release in which we decided to suppress the rendering of negative row source execution statistics.

- In 5.1.11 (2006/07/21), we added some language to the execution plan section of the report explaining why we did the statistics suppression introduced in 5.1.9.

- In 5.1.14 (2007/03/02), we added a new parameter called SHOW-NEGATIVE-ROW-SOURCE-TIMINGS. Its default value is False, which gives the 5.1.11 behavior in execution plan statistics rendering. If you set it to True, the Profiler will show some timing information, even when the Profiler has sensed that the timing information is unreliable. So now you can see the data and decide for yourself whether you want to use it.

- In release 5.1.17 (2007/06/29), we have improved the language with which the Profiler explains why it does or doesn't render the row source operation timing statistics.

Hope this helps,

Cary