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!
Name: Lasse Jenssen
Mobile: +47 92233948
- Removing unwanted “unaccounted-for …” waits from trace
- Removing idle “SQL*Net message from client” waits from trace
- Oslo April 2nd: “Mastering Oracle Trace Data” with Cary Millsap
- Speaking at #OUGN2014: “Source Control – not only for developers”
- Masking with redaction in Oracle 12c
- PLSQL: 11g datatypes for performance
- JavaZone 2013: “Oracle SQL Hacking Session: Just you, me, Java and a Oracle database”
- Solving varying IN-lists using binds in Java
- 11gR2: “Unlucky” combination of a new feature, a fix, application design and code
- New feature 11g: DBMS_SQLDIAG to dump 10053 trace
DisclaimerFor the avoidance of any doubt, all views expressed here are my own and not those of past or current employers, clients, friends, Oracle Corporation, EVRY, my Mum or, indeed, my mother in law. If you want to sue someone, I suggest you pick on Tigger, but I hope you have a good lawyer. Frankly, I doubt any of the former agree with my views or would want to be associated with them in any way.