RSS Feed

Method R Discussion Group

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.