After removing think time (or idle SQL*Net message from client) from a trace file (see a description), an unwanted line of “unaccounted for between dbcalls” dominated my MethodR profiler report. After an e-mail to MethodR support, Cary Millsap & Jeff Holt, found a way to neutralize this unwanted line. In this post I’ll show how. Thanks to Cary Millsap & Jeff Holt!

This is the profile showing the major time spent on “unaccounted-for between dbcalls”:

Totally 12.996 seconds are registered under the “unaccounted-for between dbcalls” subroutine. If we look at the “max” column we see that most of this comes from one certain point in the trace file.

Cary tipped me about using the mrskew and the “mrnl” report to find the actual line:

Do you recognize the value? Yes. This is the 12.974 seconds we want to get rid off.

Cary & Jeff then suggested to insert a dummy line, as the new line number 1690 (since line 1690 is just a time stamp. If not the new line would be inserted as line number 1991). The “ela” of the dummy line is set to the value we want to get rid off (12974359), and the “tim” value is set to the prior tim (60683300503319 ) + the dummy ela (12974359) = 60683313477678.