Method R Discussion Group

Method R helps developers, DBAs, and decision-makers optimize Oracle-based software in every phase of the software life cycle.

Discuss Method R products, techniques, and events.

Ask new questions or post your own responses.

Why doesn't the time in SQL Worksheet match R time in Profile?

When using the Hotsos Profiler Extension for SQL Developer, we notice that the elapsed time shown in the SQL Worksheet notification area (next to the iconic toolbar) doesn't match up with the response time (R) in the Profile.

These numbers do not match because they do not represent the same amount of work. The R time in the profile represents the  duration of the work done starting when the extension turns on tracing and ending when the extension turns off tracing. These events occur immediately before and after SQL Developer hands off control to our extension.

The time shown in the SQL Worksheet is done based on SQL Developer internal calculations which vary based on whether or not extensions are present, whether or not bind variables are processed, and other dependencies to which we are not privy.
Ron Crisco Send private email
Tuesday, October 2, 2007

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics
Discussion Groups Main Page

Powered by FogBugz